in reply to Re: Re: Passing boolean value to PLSQL procedure
in thread Passing boolean value to PLSQL procedure

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

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

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

In Section Seekers of Perl Wisdom