Oracle - which function is used to trap the error code and error message of an exception

GeekInterview.com > Interview Questions > Oracle

Go To First | Previous Question | Next Question

Oracle | Question 15 of 81

which function is used to trap the error code and error message of an exception

Total Answers and Comments: 5

Last Update: September 02, 2007 Asked by: majji sowjanya

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

March 19, 2006 23:28:59

prafull.vn

Member Since: March 2006 Contribution: 10

RE: which function is used to trap the error code and ...

SQLERRM -- for error Message
SQLCODE -- for error Code.

eg.

EXCEPTION
WHEN OTHERS THEN
err_code : SQLCODE;
err_msg : substr(SQLERRM 1 200);
INSERT INTO audit_table (error_code error_msg)
VALUES (err_code err_msg);
END;

Is this answer useful? Yes | No

March 20, 2006 00:20:43

gomathi.e

RE: which function is used to trap the error code and ...

dbms_output.put_line

using this we can trap the error

Is this answer useful? Yes | No

March 21, 2006 23:49:06

Rinku Rathore

RE: which function is used to trap the error code and ...

DBMS_OUTPUT.PUT_LINE is used to view the Error occured during execution the functions which are used to trap the error are

SQLCODE and SQLERRM

Is this answer useful? Yes | No

May 03, 2006 06:08:40

aseemnaithani

Member Since: February 2006 Contribution: 10

RE: which function is used to trap the error code and ...

Hi
it is Raise_Application_error

Is this answer useful? Yes | No

September 02, 2007 07:37:20

roniprasan

Member Since: September 2007 Contribution: 3

RE: which function is used to trap the error code and ...

Raise_application_error(error number error discription)

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank