Has Anyone Seen ORA-01012 From A Raised Exception To A Non-Existent Savepoint
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
0