a99e5c70   
   XPost: comp.lang.pascal.delphi.databases, comp.databases.oracle.misc   
   From: shortcutter@googlemail.com   
      
   On 12/09/2010 11:21 AM, jodleren wrote:   
   > Hi all   
   >   
   > I have tried this, but it fails. I need to call a procedure (it works   
   > we do it all the time) with parameters.   
   > The Oracle code works in an SQL editor, now we need to have it in   
   > Delphi.   
   > This does not work. Any suggestions?   
   >   
   > Sonnich   
   >   
   >      ora := TQuery.Create(nil);   
   >      ora.DatabaseName := OraSession1.DatabaseName;   
   > ora.SQL.Text := '';   
   > ora.SQL.Add('declare');   
   > ora.SQL.Add(' inv wise.Vararasto_pack.vctable;');   
   > ora.SQL.Add(' jnumero wise.Vararasto_pack.intTable;');   
   > ora.SQL.Add(' qty wise.Vararasto_pack.floatTable; ');   
   > ora.SQL.Add('begin        ');   
   > ora.SQL.Add(' inv(1) := ''inv'';             ');   
   > ora.SQL.Add(' jnumero(1) := 123546;         ');   
   > ora.SQL.Add(' qty(1) := -2;          ');   
   > ora.SQL.Add(' begin wise.VarastopaikkaSiirrot(inv,jnumero,qty,''I'');   
   > end;');   
   > ora.SQL.Add('end; ');   
   >   
   > Field '=' is of unknown type   
   >   
   > So I tried:   
   >   
   > Using a   ora2 := TStoredProc.Create(nil);   
   >    ora2.DatabaseName := OraSession1.DatabaseName;   
   >   
   > I get : General SQL Error: Syntax Error or access violation   
   >   
   > Better, but how do I do this?   
      
   I dunno Delphy but are you sure you can use Add to add text to a single   
   SQL statement?  Maybe it's the batch interface and the driver thinks   
   he's seeing a whole bunch of malformed statements.  For the block to   
   work it must be seen as a single SQL statement by Oracle.   
      
   Cheers   
      
   	robert   
      
   F'Up to comp.lang.pascal.delphi.databases   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)