Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What are the return values of functions SQLCODE and SQLERRM ?

Question Posted / guest

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,

For more SQL PLSQL Interview Questions Click Here
Categories