Re: Re: Passing boolean value to PLSQL procedure

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.

Comment on Re: Re: Passing boolean value to PLSQL procedure

Replies are listed 'Best First'.
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]