At 03:40 06/02/03 +0000, you wrote:
Many thanks to those that replied and helped me out. Steve Kell's transcript of the Database Error Messages for "PLS-00201" sparked me to look at the Oracle database and check the access rights to that function. Bingo ! The username / password I was connecting with did not have access to that function. I added the user and was in business :)Date: Wed, 05 Feb 2003 09:19:14 +1100 To: [EMAIL PROTECTED] From: David Bakkers <[EMAIL PROTECTED]> Subject: Newbie problem with Oracle functions
The other problem I encounter was binding the input parameter as the correct type. If I used...
$func->bind_param(":parameter1", 993193);
it worked, but if I used...
$func->bind_param(":parameter1", 020123);
I got an error "ORA-01008: not all variables bound". It seemed that the zero was being dropped from the parameter value being passed to the function, which was rejecting it because it expects a six digit number (we have some Student numbers with a leading zero).
Keeping the the value enclosed in comments thus...
$func->bind_param(":parameter1", '020123');
gets it correctly bound and passed.
David Bakkers, Systems Administrator.
--------------------------------------------------------------------
Central College, Sydney, Australia.
Ph:(02) 8217 9609. Fax:(02) 9211 0628
reply to [EMAIL PROTECTED]
--------------------------------------------------------------------
