Mladen Gogala
Oracle DBA
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jamadagni, Rajendra
Sent: Friday, September 26, 2003 10:05 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: equivalent for isdate, isnumericyou could however use diutil.bool_to_int and diutil.int_to_bool which is used by oracle to transmit/receive Boolean data across SqlNet.
Since others have pointed out, Boolean is not a SQL datatype, you could not build a FBI around it, deterministic or no, it doesn't make a difference. Use diutil.bool_to_int around the return value and your function returns a number (0 or 1) and now you can build a FBI.
Raj
--------------------------------------------------------------------------------
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-----Original Message-----
From: Tanel Poder [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 26, 2003 7:40 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: equivalent for isdate, isnumeric
> Called from where? :) I think Tanel, Mladen and you missed the ironical
> point -- if it can't be called from SQL why it is a deterministic one?Erm.. ee.. if you put a wrapper function over it which retuns number...
(just joking)Ok, I was too short-sighted there. I just checked from v$type_size that
boolean still exists and didn't think much more.> P.S.: Tanel, I do not need an example, it was a joke.
I actually checked whether it was possible to still conduct some kind of
working example, but didn't succed in 5 minutes, so be it ;)Tanel.