Answer / ravi

You can debug your procedure in various ways:
1: If you are using tools like Toad, PL/SQL or SQL Developer, you can place the breakpoints in the procedure and then debug the same by using step into steps.
2: If you are using SQ*Plus, you need to place DBMS_OUTPUT for messaging and trace the same.
3: You can put the trace log on in the database server and can check the trace files.

Answer / arthi

use the following code to debug the huge line of code

DBMS_OUTPUT.PUT_LINE
(dbms_utility.format_error_backtrace||' : '||sqlerrm);

How is use pl and sql?

0 Answers  

---

What is union, minus and interact commands?

0 Answers  

---

Wat is SGA ?

3 Answers   ABB,

---

How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

2 Answers   DELL,

---

What is left join in postgresql?

0 Answers  

---

Explain architecture of sql server notification services?

0 Answers  

---

Explain the components of sql?

0 Answers  

---

how to use myisamchk to check or repair myisam tables? : Sql dba

0 Answers  

---

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

0 Answers  

---

Is postgresql a nosql database?

0 Answers  

---

How is indexing done in search engines?

0 Answers  

---

In a Distributed Database System Can we execute two queries simultaneously ? Justify ?

3 Answers  

---