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
- 12034 Views
- Fidelity, I also Faced
- E-Mail Answers
Answer Posted / arthi
use the following code to debug the huge line of code
DBMS_OUTPUT.PUT_LINE
(dbms_utility.format_error_backtrace||' : '||sqlerrm);
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
How long will it take to learn pl sql?
what happens if you no create privilege in a database? : Sql dba
What is cold data?
When is the update_statistics command used?
What is rownum and rowid?
How is pl sql different from sql?
Can function return multiple values in sql?
Why do we use joins?
What is over () in sql?
What is graph sql?
Which command is used to call a stored procedure?
What are hotfixes and patches?
Why is stored procedure faster than query?
What is the left table in sql?
What is sql data?
