{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

RaiseAppErr - if erec.sal> 1000.0 then raise...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Sheet1 Page 1 /* PROGRAM DEMONSTRATES RAISE_APPLICATION_ERROR*/ declare Sal_Out_of_Range exception sal_id emp.sal%TYPE begin dbms_output.enable for erec in (select sal_id, sal from emp) loop
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: if erec.sal > 1000.0 then raise Sal_Out_of_Range end if end loop exception when Sal_Out_of_Range then raise_application_error (-20000, 'sal is out of range') end /...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online