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
- 12710 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 do I view stored procedures?
What are the dml statements?
How does sql*loader handles newline characters in a record? : aql loader
What programs use sql?
What is data profiling in sql?
What are the different types of database management systems?
How do I truncate a word?
What is java sql drivermanager?
What is the difference between sql and isql*plus?
what are integrity rules?
What jobs use sql?
What is right join sql?
what are numeric data types? : Sql dba
Can a composite key be null?
What problem one might face while writing log information to a data-base table in pl/sql?
