How will you debug your procedure? If your procedure is
around 2000 lines and the expected output is 10 and we get
only output 5.So how will you debug it?
Somebody pls give the correct answer?
- 2 Answers
- 12790 Views
- Fidelity, I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
what are the advantages of sql ? : Sql dba
what is bcp? When does it used? : Sql dba
how to escape special characters in sql statements? : Sql dba
Can we use distinct and group by together?
What is the current version of postgresql?
Is primary key always clustered index?
Can delete statement be rollbacked?
how to start mysql server? : Sql dba
Is inner join faster than left join?
define sql insert statement ? : Sql dba
what is schema? : Sql dba
If a cursor is open, how can we find in a pl/sql block?
how many tables will create when we create table, what are they? : Sql dba
Does group by remove duplicates?
Do we need to rebuild index after truncate?
