raise_application_error message [message #338250] |
Mon, 04 August 2008 05:41  |
bhoite_amol83
Messages: 110 Registered: June 2005 Location: Pune
|
Senior Member |
|
|
When i execute the below code it gives ,
ORA-20100: Provided Parent ID Is Not Present In Parent Table
ORA-06512: at line 11
But i need only output,
20100: Provided Parent ID Is Not Present In Parent Table
How can i do it?
DECLARE
p_exists NUMBER(1);
BEGIN
SELECT empno
INTO p_exists
FROM empl
WHERE empno = 1
AND ROWNUM = 1;
EXCEPTION
WHEN NO_DATA_FOUND THEN
RAISE_APPLICATION_ERROR(-20100,'Provided Parent ID Is Not Present In Parent Table');
END;
ORA-20100: Provided Parent ID Is Not Present In Parent Table
ORA-06512: at line 11
Thanks,
|
|
|
|
|
|
|