Ora2Pg Migration – PRAGMA AUTONOMOUS_TRANSACTION

The PRAGMA AUTONOMOUS_TRANSACTION is one of the technique in oracle used to make sure the sub-program runs in different transaction with out affecting main transaction.

The usecase you might find such thing exists in oracle is to write error or audit the failures.

During Oracle two ProgreSQL Migration, never mind – PRAGMA AUTONOMOUS_TRANSACTION doesn’t exists in PostgreSQL and the workaround suggested here will not scale. If you are using dblink you need to keep following things in mind,

  • The connection string, username and password is exposed here
  • We will need to configure more number of connections in the Database based on load which is very difficult to get in all practical reason.

This will burn your hands not in Dev, QE but definitely a good Perf test will bring it to closure.

Leave a Reply

Your email address will not be published.

WP2Social Auto Publish Powered By : XYZScripts.com