Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h8QGEwZ08940 for ; Fri, 26 Sep 2003 11:14:58 -0500 X-ClientAddr: 66.27.56.213 Received: from www2.fatcity.com (rrcs-west-66-27-56-213.biz.rr.com [66.27.56.213]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h8QGEvc08935 for ; Fri, 26 Sep 2003 11:14:57 -0500 Received: (from root@localhost) by www2.fatcity.com (8.11.6/8.11.6) id h8QDZpu22697 for oracle-l@orafaq.net; Fri, 26 Sep 2003 06:35:51 -0700 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005D12F4; Fri, 26 Sep 2003 06:19:39 -0800 Message-ID: Date: Fri, 26 Sep 2003 06:19:39 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Mladen Gogala" Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Mladen Gogala" Subject: RE: equivalent for isdate, isnumeric Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0019_01C3840F.287CCFB0" ------=_NextPart_000_0019_01C3840F.287CCFB0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Or, the function can be written to return number. It's not so hard to do.= =20If there are problems, please let me know, I'll post the new version of the code, wrapped. =20 =20 -- Mladen Gogala Oracle DBA=20 -----Original Message----- Jamadagni, Rajendra Sent: Friday, September 26, 2003 10:05 AM To: Multiple recipients of list ORACLE-L you 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 n= ot 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=20 -------------------------------------------------------------------------= --- ----=20 Rajendra dot Jamadagni at nospamespn dot com=20 All Views expressed in this email are strictly personal.=20 QOTD: Any clod can have facts, having an opinion is an art !=20 -----Original Message-----=20 Sent: Friday, September 26, 2003 7:40 AM=20 To: Multiple recipients of list ORACLE-L=20 > Called from where? :) I think Tanel, Mladen and you missed the ironical= =20 > 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...=20 (just joking)=20 Ok, I was too short-sighted there. I just checked from v$type_size that=20 boolean still exists and didn't think much more.=20 > P.S.: Tanel, I do not need an example, it was a joke.=20 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 ;)=20 Tanel.=20 Note: This message is for the named person's use only. It may contain confiden= tial, proprietary or legally privileged information. No confidentiality = or privilege is waived or lost by any mistransmission. If you receive th= is message in error, please immediately delete it and all copies of it fr= om your system, destroy any hard copies of it and notify the sender. You= =20must not, directly or indirectly, use, disclose, distribute, print, or= =20copy any part of this message if you are not the intended recipient. W= ang Trading LLC and any of its subsidiaries each reserve the right to mon= itor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, e= xcept where the message states otherwise and the sender is authorized to = state them to be the views of any such entity. ------=_NextPart_000_0019_01C3840F.287CCFB0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Message
Or,=20 the function can be written to return number. It's not so hard to do. If = there=20 are problems,
please=20 let me know, I'll post the new version of the code, wrapped.
 
 
--
Mladen Gogala
Oracle DBA
=20
=20
-----Original Message-----
From:=20 =20 ml-errors@fatcity.com [mailto:ml-errors@fatcity.com] On Behalf Of = =20 Jamadagni, Rajendra
Sent: Friday, September 26, 2003 10= :05=20 =20 AM
To: Multiple recipients of list ORACLE-L
Subject:<= /B> RE:=20 =20 equivalent for isdate, isnumeric

=20

you could however use diutil.bool_to_int and=20 =20 diutil.int_to_bool which is used by oracle to transmit/receive Boolea= n data=20 =20 across SqlNet.

=20

Since others have pointed out, Boolean is not a SQL= =20datatype,=20 =20 you could not build a FBI around it, deterministic or no, it doesn't = make a=20 =20 difference. Use diutil.bool_to_int around the return value and your f= unction=20 =20 returns a number (0 or 1) and now you can build a FBI.

=20

Raj
------------------------------------------------------------= --------------------=20 =20
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.=20 =20
QOTD: Any clod can have facts, having an opinion i= s an art=20 =20 !


=20

-----Original Message-----
From: Tanel=20 =20 Poder [mailto:tanel.poder.003@mail.e= e]=20 =20
Sent: Friday, September 26, 2003 7:40 AM To: Multiple recipients of list ORACLE-L
Subject: Re: equivalent for isdate, isnumeric

=20

> Called from where? :) I think Tanel, Mladen an= d you=20 =20 missed the ironical
> point -- if it can= 't be=20 =20 called from SQL why it is a deterministic one?

=20

Erm.. ee.. if you put a wrapper function over it wh= ich retuns=20 =20 number...
(just joking)

=20

Ok, I was too short-sighted there. I just checked f= rom=20 =20 v$type_size that
boolean still exists and d= idn't think=20 =20 much more.

=20

> P.S.: Tanel, I do not need an example, it was = a=20 =20 joke.

=20

I actually checked whether it was possible to still= =20conduct=20 =20 some kind of
working example, but didn't su= cced in 5=20 =20 minutes, so be it ;)

=20

Tanel.

 
Note:
This message is for the named person's use only.  It may contai= n=20 confidential, proprietary or legally privileged information.  No=20 confidentiality or privilege is waived or lost by any mistransmission.&nb= sp; If=20 you receive this message in error, please immediately delete it and = all=20 copies of it from your system, destroy any hard copies of it and notify t= he=20 sender.  You must not, directly or indirectly, use, disclose, distri= bute,=20 print, or copy any part of this message if you are not the intended=20 recipient. Wang Trading=20 LLC and any of its subsidiaries each reserve the rig= ht to=20 monitor all e-mail communications through its networks.  Any views=20 expressed in this message are those of the individual sender, except wher= e the=20 message states otherwise and the sender is authorized to state them to be= =20the=20 views of any such entity.
 
 
------=_NextPart_000_0019_01C3840F.287CCFB0-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: mladen@wangtrading.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).