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.

Report message to a moderator

Re: PHP & OCIBindByName [message #130734 is a reply to message #130258] Tue, 02 August 2005 03:29 Go to previous message
Frank Naude
Messages: 4587
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 02 08:36:06 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.