PL/SQL (MOSC)

MOSC Banner

Has Anyone Seen ORA-01012 From A Raised Exception To A Non-Existent Savepoint

edited Nov 15, 2011 3:31AM in PL/SQL (MOSC) 12 comments
We have a package within which proc A calls proc B.  Proc A establishes a savepoint before it calls proc B.  In the Exceptions Section of proc B, an unqualified (complete) rollback is performed, and then the exception raised back to proc A.  Proc A's Exception Section does a rollback to its savepoint, which generates the error I am listing below.  I am a DBA and have explained the error of this coding to the application team.  Still, some are wondering if the ORA-01012 might be related to a networking issue, because proc B is called across a Db_Link.  This db_link is named

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center