Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

illegal variable name/number

449323Jul 28 2007 — edited Aug 2 2007
I am calling a stored procedure from my php program and get the following error/warning:-
Warning: ocibindbyname() [function.ocibindbyname]: OCIBindByName: ORA-01036: illegal variable name/number in C:\Program Files\Apache Group\Apache2\htdocs\Events\OracleGetClientTest.php on line 111

Warning: ocibindbyname() [function.ocibindbyname]: OCIBindByName: ORA-01036: illegal variable name/number in C:\Program Files\Apache Group\Apache2\htdocs\Events\OracleGetClientTest.php on line 112

My code looks like:-
$StartDate="2006/01/01 06:00:00";
$EndDate="2007/07/26 17:00:00";
$SQL = "begin spPackage.spTablesPlayed(:p_number, :p_recordset); end;";



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

$curs = OCINewCursor($conn);

if (!$stmt)

{

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

die();

}

OCIBindByName($stmt,":p_number",&$number,15);
OCIBindByName($stmt,":p_startdate",&$StartDate, 20); <-------- line 111

OCIBindByName($stmt,":p_enddate",&$EndDate, 20); <-------- line 112

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

and the relevant piece of the stored procedure look like:-

PROCEDURE spTablesPlayed(
p_number cards.card_number%type, --varchar2
p_startdate varchar2,
p_enddate varchar2,
cv_tablesplayed out tablesplayed_cur_type);

Please tell me what I am misunderstanding.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 30 2007
Added on Jul 28 2007
5 comments
818 views