RE: this drove me crazy!!!

From: Abdul Aleem <abchaudhary-ho_at_beaconhouse.edu.pk>
Date: Mon, 12 Feb 2001 22:06:50 -0800
Message-ID: <F001.002B22C0.20010212220023@fatcity.com>

Katz,

I am sure you are not the CUSTOMER as mentioned by MOHAMMAD AMER in the original mail ^_^.

Aleem

-----Original Message-----
[mailto:Chaim.Katz_at_Completions.Bombardier.com] Sent: Tuesday, February 13, 2001 12:45 AM

To:     Multiple recipients of list ORACLE-L
Subject:        RE: this drove me crazy!!!

<< File: ATT01374.txt >>

I can do it.
SQL> create or replace function dumb
  2 return number is
  3 pragma autonomous_transaction;
  4 begin
  5 insert into emp (empno) values (10);   6 commit;
  7 return 0;
  8 end;
  9 /

Function created.

Try a few of these:

SQL> select empno
  2 from emp
  3 where dumb=0 and
  4 empno < 20;

"Boivin, Patrice J" <BoivinP_at_mar.dfo-mpo.gc.ca> on 02/12/2001 08:55:37 AM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Chaim Katz/Completions/Bombardier)

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Abdul Aleem
INET: abchaudhary-ho_at_beaconhouse.edu.pk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_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). Received on Tue Feb 13 2001 - 00:06:50 CST