Re: need 1 record asynchrnous inserts - DBMS_PIPE? DBMS_AQ? something else?

Sorry, allow me to clarify - autonomous transaction will not work with distributed transactions. This is functionality that will *not work* on oracle 8.1.7 or on Oracle 9i.. I mispoke.. Bug 692232 is the bug for 8.1.7.. However it *does* work on 8.1.5, despite that there is a warning in the release notes for what is an unpublished bug I believe..

Here is a code snippet that will run perfectly on 8.1.5, but not 8.1.7 or 9i... Note the db_link makes it distributed...

• cut -- CREATE OR REPLACE PROCEDURE vwmtest AS -- v_date DATE; -- ----------------- local module ------------------------------------------- PROCEDURE WRITE_LOG IS pragma AUTONOMOUS_TRANSACTION; Begin INSERT INTO ofs_intf_log VALUES ('VWMTEST','D',0,SYSDATE,SYSDATE,0,0,0,0,1,'F','B',3); -- COMMIT; -- EXCEPTION WHEN OTHERS THEN dbms_output.put_line('Others error in write_log'); -- End WRITE_LOG;

  ---

  BEGIN -- SELECT product_date INTO v_date FROM SOMETABLE_at_G4XX.WORLD WHERE item = 31283; -- WRITE_LOG; -- EXCEPTION WHEN OTHERS THEN dbms_output.put_line('Others error in vwmtest'); -- END vwmtest;

In any case.. rather than alarm people about autonomous transactions, I was hoping for a subsitute for them using pipe for example..

Sorry for the confusion..

On Sat, 02 Jun 2001 19:56:18 GMT, Mark Townsend <markbtownsend_at_home.com> wrote:

>in article 20010602.152552.1476153275.3461_at_bobak.net, Mark J. Bobak at
>mark.NOSPAM_at_bobak.net wrote on 6/2/01 12:25 PM:
>
>> Nor am I aware of any
>> reason autonomous transactions should disappear in 9i.
>>
>> ...stuff deleted......
>>
>>> I'll keep reading.. but I thought someone may have been there before...
>>>
>> You should try reading the application developers guide.
>> Try:
>> http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.81
>> 7/a76939/adg08sql.htm#8266
>>
>> Hope this helps,
>
>Autonomous transactions are definately in Oracle9i - see
>http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/appdev.901/
>a88876/adg08sql.htm
Received on Sat Jun 02 2001 - 22:41:56 CDT