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)