Answer / welcomeashwin

PRAGMA EXCEPTION_INIT allows to associate an Oracle error
number with the name of a user-defined error. Here you need
to defined user-defined exception before it is used in
PRAGMA EXCEPTION_INIT. There are two parameters: exception
name and error code.

RAISE_APPLICATION_ERROR allows to create meaningful error
msg.it works with un-named user defined exceptions. It
associates the number of the error with the text of the
error. Therefore, the user-defined exception does nat have a
name associated with it. There are three parameter:
err_number, err_msg, keep-err

what is bcp? When does it used? : Sql dba

0 Answers  

---

overloading of stored procedure is possible in oracle?

3 Answers   Nelco,

---

How to create an array in pl/sql?

0 Answers  

---

What is the difference between DELETE, TRUNCATE, and DROP?

3 Answers  

---

What does desc stand for?

0 Answers  

---

---

Can we insert data into view?

0 Answers  

---

Can I learn sql in a week?

0 Answers  

---

where are cookies actually stored on the hard disk? : Sql dba

0 Answers  

---

Explain the significance of the & and && operators in pl sql.

0 Answers  

---

What does subquery mean in sql?

0 Answers  

---

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

0 Answers  

---

how to create object in plsql

3 Answers   Microsoft,

---