What are the return values of functions SQLCODE and SQLERRM ?

Answers were Sorted based on User's Feedback



What are the return values of functions SQLCODE and SQLERRM ?..

Answer / tulsi

SQLCODE returns the latest code of the error that has
occured.
SQLERRM returns the relevant error message of the SQLCODE.

Is This Answer Correct ?    16 Yes 0 No

What are the return values of functions SQLCODE and SQLERRM ?..

Answer / pervez

Hi Tulsi,
Sqlerrm returns error number as well as error message of
last error occured.

Is This Answer Correct ?    4 Yes 2 No

Post New Answer

More SQL PLSQL Interview Questions

What is the purpose of cursors in pl/sql?

0 Answers  


Why are sql stored procedures used?

0 Answers  


Why we use join in sql?

0 Answers  


Is nosql relational?

0 Answers  


What are the types of SQL Statement?

3 Answers  


What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?

2 Answers   JDA,


What is pl sql quora?

0 Answers  


what is global variable in pl/sql

1 Answers  


how can i read files from a pl/sq l program

3 Answers  


Define SQL and state the differences between SQL and other conventional programming Languages?

0 Answers  


Explain the components of sql?

0 Answers  


How toimport .dmp file in lower version of oracle from higher version ?

4 Answers   TCS,


Categories