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
- 12614 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 are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What is a join?
How do I know if I have sql express or standard?
In a distributed database system, can we execute two queries simultaneously?
what are the authentication modes in sql server? How can it be changed? : Sql dba
what is the difference between char_length and length? : Sql dba
How do sql databases work?
give the syntax of grant and revoke commands? : Sql dba
How insert into statements in sql?
How do I find duplicates in sql?
What is character functions?
What is interval partition?
Can there be more than one function with a similar name in a pl/sql block?
Can we create clustered index without primary key?
What is identity column in sql server?
