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
- 12787 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
What is the current version of postgresql?
what is schema? : Sql dba
Is primary key always clustered index?
What is the current version of sql?
Can delete statement be rollbacked?
what are the advantages of sql ? : Sql dba
Is inner join faster than left join?
what are all the common sql function? : Sql dba
what is dbms? : Sql dba
Do we need to rebuild index after truncate?
define sql insert statement ? : Sql dba
Can we rollback truncate?
What is your daily office routine?
what is sql server agent? : Sql dba
If a cursor is open, how can we find in a pl/sql block?
