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);

what is error ora-03113: end-of-file on communication channel?

0 Answers  

---

What do you think about pl/sql?

0 Answers  

---

What is compiled query?

0 Answers  

---

explain primary keys and auto increment fields in mysql : sql dba

0 Answers  

---

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?

13 Answers   Cap Gemini, TCS,

---

How does one use sql*loader to load images, sound clips and documents? : aql loader

0 Answers  

---

Why do we go for stored procedures?

0 Answers  

---

how can stop the sequence with mention the max value and with out mention the max value

1 Answers   Zensar,

---

diff b/w function and procedure?

9 Answers   iFlex,

---

What is the maximum rows in csv?

0 Answers  

---

When would you denormalize?

8 Answers   MBT, Microsoft, MMU,

---

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

0 Answers  

---