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
- 12039 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 is %type in sql?
what is the difference between truncate and delete statement? : Transact sql
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
What is sap sql anywhere?
What are the different types of joins in sql?
Explain the select statement in sql?
What does subquery mean in sql?
what are the properties and different types of sub-queries? : Sql dba
How much does sql certification cost?
How does stored procedure reduce network traffic?
what is the difference between a web-garden and a web-farm? : Sql dba
how to use like conditions? : Sql dba
What is cursor status?
Can you call pl/sql package functions from within a fast formula?
What is the difference between sql and t sql?
