Oracle Applications Knowledge Repository
Tuesday, January 18, 2011
Oracle - RAISE_APPLICATION_ERROR
DECLARE
EMPID
NUMBER
(
3
)
:=
25
;
BEGIN
DELETE
FROM
TEMPEMP
WHERE
ID
=
EMPID
;
IF
SQL
%
NOTFOUND
THEN
RAISE_APPLICATION_ERROR
(-
20202
,
'INVLID EMPLOYEE'
);
END
IF;
END;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment