Skip to Main Content

DevOps, CI/CD and Automation

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!

OCIBindByName: ORA-01036: illegal variable name/number

449323Jul 28 2007 — edited Jul 30 2007
My PHP variable definition looks like:-
$StartDate="2006/01/01 06:00:00";
$EndDate="2007/07/26 17:00:00";

the stored procedure I am trying to use contains

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

and I get the following error

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

at my line

OCIBindByName($stmt,":p_startdate",&$StartDate, 20);

Please tell me what I have misunderstood/misdefined.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 27 2007
Added on Jul 28 2007
4 comments
7,467 views