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
- 12718 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
Why coalesce is used in sql?
Does sql full backup truncate logs?
What is plpgsql language?
What is a full join sql?
what is a database lock ? : Sql dba
What are the parts of a sql statement?
What is pl sql block in dbms?
Is sql an operating system?
Why indexing is needed?
What are sql functions? Describe the different types of sql functions?
What is informix sql?
how can we repair a mysql table? : Sql dba
How does pl sql work?
What is %s in sql?
How many tables can a sql database have?
