PL/SQL (MOSC)

MOSC Banner

Exception handling in PLSQL

edited Jan 23, 2014 4:50AM in PL/SQL (MOSC) 7 commentsAnswered ✓
Hi,

 I am trying to write a Stored procedure which will delete the contents of a table(>3000000 records) at a time. I have implememted logic to break down the records into sizable chunks and then delete. But still intermittently I get ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'  while running the Stored proceedure. Please let me know how to handle this in the SP and capture the error code and desc.

Also is there any way to handle general runtime exceptions and capture the error code and desc. I have 2 out params which is meant to send back the error code and desc.

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