Home » Open Source » Programming Interfaces » PHP & OCIBindByName
PHP & OCIBindByName [message #130258] Fri, 29 July 2005 01:12 Go to next message
stockton
Messages: 10
Registered: July 2005
Location: South Africa
Junior Member
I am obviously not understanding the OCIBindByName function as I get the following warning when I run my program:-
Warning: ocibindbyname() [function.ocibindbyname]: OCIBindByName: ORA-01036: illegal variable name/number in C:\Program Files\Apache Group\Apache2\htdocs\Kiosk\GetMember.php on line 47

My code looks like :-

$s = OCIParse($c, "begin sp_member_detail(:number, :num) end;");
OCIBindByName($s, ":cardNumber", $number);

So I assume that my understanding of OCIBindByName is wrong. Please explain.
Re: PHP & OCIBindByName [message #130734 is a reply to message #130258] Tue, 02 August 2005 03:29 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

You need bind calls for :number and :num (as listed in your parse call), not for :cardNumber.

Best regards.

Frank
Previous Topic: connection with PHP
Next Topic: PHP config error ocidfn.h file not found
Goto Forum:
  


Current Time: Thu Mar 28 14:06:45 CDT 2024