help on getting: OCIStmtExecute - no statement parsed

[danielemasson]

Hello every1, if anyone knows about PHP & ORACLE

im getting

Warning: OCIStmtExecute: ORA-00604: error occurred at recursive SQL level 1 ORA-01003: no statement parsed in /local2/docs-trtiempo/temadeldia/consultaOpinion.php on line 51 ..

i just cant see my mistake here, the line of the error here is number 7

1 $con = OCILogon($USR, $PWD, $NBD);
2 $SQL1 = "begin CONSULTAR_COMENTARIO('$id_padre', '$id_articulo',:cursor,:num_comentarios); end;";
3 $cursor_opiniones = OCINewCursor($con);
4 $stmt = OCIParse($con,$SQL1);
5 OCIBindByName($stmt,":cursor",&$cursor_opiniones,-1,OCI_B_CURSOR);
6 OCIBindByName($stmt,":num_comentarios",&$tot_registros,16);
7 OCIExecute($stmt);
8 OCIExecute($cursor_opiniones);
9 OCIFreeStatement($stmt);

 

[ingresman]

Is CONSULTAR_COMENTARIO a stored procedure or package ?
Have you tried running the statement on it's own in SQL*plus ??
is line 7 really line 51 (as in the original error)?
regards

 

[danielemasson]

yes line 7 is 51, ...
it is a stored_procedure, .. it runs succesfully on sqlplus and is has no erros ...

 

[ingresman]

mmmm interesting I'll have a think