Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> how to write a Autonomous Transactions proc with PL/SQL 8.0.5

how to write a Autonomous Transactions proc with PL/SQL 8.0.5

From: <guanjian_at_my-dejanews.com>
Date: Thu, 29 Apr 1999 13:26:36 GMT
Message-ID: <7g9mm6$cjj$1@nnrp1.dejanews.com>


hi,

thanks for read this.

i have some functions and procedures written by PL/SQL 8.0.5, and i use some commit in them. but somebody tell me that will commit the caller 's transaction, is it right?

i read some book, find a pragma " Autonomous_Transaction" , but it only work in PL/SQL 8.1, so how to do this in PL/SQL 8.0.5 ?

any idea?

thanks a lot.

yours probing.
probing_at_rocketmail.com

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Apr 29 1999 - 08:26:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US