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 company owns postgresql?

0 Answers  


What are the different types of database management systems?

0 Answers  


Why do we use sqlite?

0 Answers  


How do I know if I have sql express or standard?

0 Answers  


Why is sharding used?

0 Answers  






How to download oracle sql developer?

0 Answers  


Why is a primary key important?

0 Answers  


Do we need to rebuild index after truncate?

0 Answers  


how many tupples can insert in 1 second in sql

1 Answers  


If you have to declare procedure1,procedure2 in package specification and if you have to declare procedure1,procedure2 and procedure3 in package body? is it compilation or not and execute or not? what type of error is given please

1 Answers  


What are few of the schema objects that are created using PL/SQL?

0 Answers  


types of exceptions and what is meant by pragma autonomous_transaction ?what is the use.

4 Answers   3i Infotech,


Categories