abases,comp.databases.oracle.misc   
   oglegroups.com>   
   9eaa7185   
   GMT)   
   posting-account=OiJc3goAAACVckaxOSC-aEp1AzEnXor2   
   comp.lang.pascal.delphi.databases:30 comp.databases.oracle.misc:2297   
   From: jodleren    
      
   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?   
      
   Sonnich   
      
   --- Internet Rex 2.31   
    * Origin: The gateway at Omicron Theta (1:261/20.999)