| illegal variable name/number [message #254633] |
Fri, 27 July 2007 05:44  |
stockton
Messages: 10
Registered: July 2005
Location: South Africa
|
Junior Member |
|
|
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
