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

Does user triggers have entry for trigger with compilation errors?

0 Answers  

---

table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004

2 Answers   Maruti Suzuki,

---

Is inner join same as self join?

0 Answers  

---

Explain autonomous transaction.

0 Answers  

---

If you want a column to be part of the result set, after which SQL keyword does it belong? 1. SELECT 2. FROM 3. WHERE 4. GROUP BY 5. HAVING

10 Answers   HCL, TCS,

---

What is the difference between distinct and unique in sql?

0 Answers  

---

What are basic techniques of indexing?

0 Answers  

---

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

0 Answers  

---

what are the differences between char and nchar? : Sql dba

0 Answers  

---

Define overloaded procedure?

0 Answers  

---

what are string data types? : Sql dba

0 Answers  

---

What is count * in sql?

0 Answers  

---