php problem with stored procedures

[Anon]

connection to oracel...

$curs = OCINewCursor($conn);
$stmt = OCIParse($conn,"begin www.testloginproc('test1','pwd1', :trades ); end;");

ocibindbyname($stmt,"trades",&$curs,-1, OCI_B_CURSOR);
ociexecute($stmt);
ociexecute($curs);

ever get the error
wrong number or types of arguments in call
but the stored procedure has 3 arguments

does anyone know whats goin on there

[toma42]

I don't think you can have to statements in your sql. Try breaking the end; into a new sql stetement.

[steved]

try changing your bind statement so that the second parameter has a colon in front, like:

ocibindbyname($stmt,":trades",&$curs,-1, OCI_B_CURSOR);

[Anon]

... jo, and also a hint, that you will get some problems, if :trade is an OUT value,
then you need to know, how big this value could be.
-1 as limitation of ocibind won't work.