PROCEDURE Test_Exception_Handling
IS
BEGIN
-- TODO: Pre Logic
Dbms_Output.Put_Line('Pre Logic');
BEGIN
@ApproveTransactionStatement(2024-11-21, RMAX)
SAVEPOINT A;
-- TODO: Main Logic
Dbms_Output.Put_Line('Main Logic');
-- Error Demo
Error_SYS.Record_General(lu_name_, 'TEMPERROR: RMAX DUMMY 101');
EXCEPTION
WHEN OTHERS THEN
@ApproveTransactionStatement(2024-11-21, RMAX)
ROLLBACK TO A;
-- TODO: Error Handling Logic
Dbms_Output.Put_Line('Error Handling Logic');
END;
END Test_Exception_Handling;
top of page
Related Posts
See All[FndWindowRegistration("YVVDA_COMPANY_ADDR", "YvvdaCompanyAddr", FndWindowRegistrationFlags.HomePage)] [FndDynamicTabPage("frmCompanyAddr...
40
Example 1: SELECT DISTINCT LISTAGG(t.commission_receiver, ';') WITHIN GROUP (ORDER BY t.commission_receiver) FROM...
20
FUNCTION Strip_Ora_Error ( sqlerrm_ IN VARCHAR2, sqlcode_ IN NUMBER DEFAULT NULL, strip_ora_only_ IN BOOLEAN DEFAULT...
10
bottom of page
Comments