Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12492 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 query cache in mysql? : Sql dba
What is application trigger?
Is sql harder than python?
Does truncate require commit?
Why triggers are used?
What are expressions?
In a distributed database system, can we execute two queries simultaneously?
How to raise user-defined exception with custom sqlerrm ?
What will you get by the cursor attribute sql%notfound?
what is a table in a database ? : Sql dba
Are subqueries better than joins?
Explain how exception handling is done in advance pl/sql?
What is an ndf file?
explain the difference between delete , truncate and drop commands? : Sql dba
Do ddl statements need commit?
