[SOLVED] call to StoredProcedure returning ORA-06550

[stockton]

Please tell me what the following means:-

 

Warning: ociexecute() [function.ociexecute]: OCIStmtExecute: ORA-06550: line 1, column 7: PLS-00905: object BIG.SPPACKAGE is invalid ORA-06550: line 1, column 7: PL/SQL: Statement ignored in C:\Program Files\Apache Group\Apache2\htdocs\Events\OracleGetClientTest.php on line 44

 

The code around line 44 looks like:-

  $SQL = "begin spPackage.spMemberDetails(_number, _recordset); end;";

 

 

$curs = OCINewCursor($conn);

  $stmt = OCIParse($conn, $SQL );

 

  if (!$stmt)

{

 

        trigger_error(sprintf("Cannot parse query for [%s] ", $number), E_USER_ERROR);

 

        die();

 

        }

OCIBindByName($stmt,"_number",&$number,15);

OCIBindByName($stmt,"_recordset",&$curs,10,OCI_B_CURSOR);

 

  $exec = OCIExecute($stmt);

 

and OCIExecute is Line 44.

 

 

[stockton]

Found it and rectified my fault.