Question
What are sqlcode and sqlerrm and why are they important for pl/sql developers?

Answers

SQLCODE returns the value of the error number for the last error encountered. The SQLERRM returns the actual error message for the last error encountered. They can be used in exception handling to report, or, store in an error log table, the error that occurred in the code. These are especially useful for the WHEN OTHERS exception.   Your Comment




More Software,developers Questions..
What is the inputsplit in map reduce software?

What is software configuration management?

What Is Java Api For Xml-based Rpc (jax-rpc)?

How can you implement fine-grained auditing?

What is IBM’s simple explanation for Big Data’s four critical features?

What is static synchronized method in JDBC API? Give an example?

What does the NULLIF function do?

What happens if a start method is not invoked and the run method is directly invoked?

Should we override finalize method

what is the difference between mysql_fetch_array and mysql_fetch_object?

How will XML affect my document links?

Why to use Style Sheets?

What are Filters in MVC?

Can you explain Application layer in OSI model?

How to define new testplan attributes?

What are the minimum system requirements to run Photoshop? Is it possible to run Photoshop over linux?

Which oracle package is used to manage the oracle lock management services?

What is Latch Up? Explain Latch Up with cross section of a CMOS Inverter. How do you avoid Latch Up?

What is marker interface?

What types of partitioning are there for BW?



Search
Can you Answer!!
  • Q IFSC code consist of _____ character?
  • Q Explain complement operator(!) in java with example?
  • Q Why do I get weird results when using both AND and OR in a query?
  • Q Kirchhoff’s voltage law is based on the law of conservation of which thing?
  • Q Methods to dry up wet induction motors?
  • Q Which renowned Indian jurist's autobiography is 'Roses in December'?
  • Q Which country hosted G-20 summit meeting in 2013 ?
  • Q What is the difference between Critical speed and Whirling speed?
  • Q What is the ruling on blood that coagulates under the fingernail, being the result of a blow or some other cause? This blood then moves gradually to the outside and it is not possible to remove it. Is this blood ritually impure or ritually pure? And how is it treated if it is considered ritually impure?
  • Q How do we do asynchronous processing using ajax
  • Q How does ms-dos interpret commands?