RE: this drove me crazy!!!

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) Received on Mon Feb 12 2001 - 14:38:46 CST