Re: 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?

Comment on Re: Passing boolean value to PLSQL procedure

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.	[reply]
Re: Re: Re: Passing boolean value to PLSQL procedure by agoth (Chaplain) on Jul 10, 2001 at 16:26 UTC
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	[reply]
Re: Re: Re: Re: Passing boolean value to PLSQL procedure by Billy (Novice) on Jul 10, 2001 at 16:53 UTC
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.	[reply]