What are the return values of functions SQLCODE and SQLERRM ?

 SQLCODE returns the latest code of the error that has occurred.SQLERRM returns the relevant error message of the SQLCODE.
  • Interview Candidate
  • 4
  • 6021

Showing Answers 1 - 4 of 4 Answers

acpsrinivas

  • Feb 25th, 2006
 

Pl / Sql Provides Error Information via two Built-in functions, SQLCODE & SQLERRM.

SQLCODE Returns the Current Error Code.

              Returns 1.

SQLERRM  Returns the Current Error Message Text.

               Returns  " User Defined Exception  "

Cheers,

Bonthu.

  Was this answer useful?  Yes

g_sidhu

  • Jan 31st, 2008
 

• SQLCODE: Returns the numeric value for the error code• SQLERRM: Returns the message associated with the error numberSQLCODE Value                  Description

0                                                                                            No exception encountered

1                                              User-defined exception

+100                                        NO_DATA_FOUND exception

negative number                     Another Oracle server error number

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions