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?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
What is an example of translating a date into julian format?
define sql
How many types of cursors supported in pl/sql?
what is sql in mysql? : Sql dba
how to install mysql? : Sql dba
What is trigger in sql and its types?
Can we create table in function?
How the execution will be done in exceptions?
What is the process of copying data from table a to table b?
what is the syntax used for partition in tsql? : Transact sql
i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL 9 10 11 12 NULL. I WANT COUNT OF NULL VALUES IN TABLE. WRITE A QUERY.
What is output spooling in sql*plus?