Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

Re: Passing boolean value to PLSQL procedure

by agoth (Chaplain)
on Jul 10, 2001 at 15:33 UTC ( [id://95273]=note: print w/replies, xml ) Need Help??


in reply to Passing boolean value to PLSQL procedure

Does your procedure compile on oracle in the first place??
Is EVENT a valid type?
Can you be sure from those errors that its the true thats the problem? and not:

p_user IN valid_users.userid%TYPE

Just thoughts, I don't have access to Oracle at the moment to be able to test TRUE out for you.
Have you tried passing in 1 for true?? and 'TRUE' quoted?

Replies are listed 'Best First'.
Re: Re: Passing boolean value to PLSQL procedure
by Billy (Novice) on Jul 10, 2001 at 16:10 UTC
    Hi. Yes the procedure does compile and EVENT is a valid type.
    I have run the procedure in SQLPLUS and it works fine With the value TRUE (or FALSE), but if I quote it (ie. 'TRUE') it returns the same error as my perl script.
    I have tried passing values 1, 0, T, F but have had no joy. The procedure does seem to be expecting the value TRUE or FALSE, but not the strings 'TRUE' or 'FALSE'. Cheers. BIlly.
      I have a feeling you can use bind to tie a specific variable to a datatype but I'm reaching here.

      I had problems in the past getting oracle to accept NULL for what it was and not a string, but cant yet find the code sample.
      Sorry I can't be any more help

        I'm not sure if there is a SQL_BOOLEAN type I can bind my variable to but I'll keep looking :-)

        In the mean time I have changed my stored procedure to take an ingeger 1 or 0 instead to map to TRUE or FALSE. Thanks for your help!

        Hows the weather in London? Crappy here (Bath).

        Cheers.
        Billy.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://95273]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others sharing their wisdom with the Monastery: (6)
As of 2024-03-28 22:57 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found