Procedure successful when using dbms_job, but fails in a shell script

Posted on 2006-05-23
Last Modified: 2008-02-20
I have a procedure which is throwing the following error when run from a shell script. This procedure completes successfully when run using dbms_job

ORA-00164 distributed autonomous transaction disallowed within migratable distributed transaction
Question by:MohanKNair
    1 Comment
    LVL 19

    Accepted Solution

    ORA-00164:      distributed autonomous transaction disallowed within migratable distributed transaction
    Cause:      A request was made by the application to start a distributed autonomous transaction when the application was in a migratable distributed transaction.
    Action:      Roll back or commit the current distributed transaction first.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
    Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now