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
‹
›
Home
View web version
No comments:
Post a Comment