I have a sql server stored procedure that uses a try catch block and then does a rollback if an error occurs. Can someone show me how to do the same thing in Oracle Syntax?
CREATE OR REPLACE PROCEDURE MYPROC
BEGIN TRY -- Close to top of my stored procedure
IF @@TRANCOUNT > 0