When troubleshooting Perl/DBI/Oracle problems such
as this, the first thing you should do is try the operation
from sqlplus. If it won't work in sqlplus, it certainly won't
work from DBI.
Jared
On Thursday 06 February 2003 21:46, David Bakkers wrote:
> At 03:40 06/02/03 +0000, you wrote:
> >Date: Wed, 05 Feb 2003 09:19:14 +1100
> >To: [EMAIL PROTECTED]
>
> From: David Bakkers <[EMAIL PROTECTED]>
>
> >Subject: Newbie problem with Oracle functions
>
> 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 :)
>
> 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]
> --------------------------------------------------------------------
