use the following code to debug the huge line of code DBMS_OUTPUT.PUT

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?

Question Posted / arthi

2 Answers
12587 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

Please Help Members By Posting Answers For Below Questions

Show code of a cursor for loop.

1052

What is a full join?

968

What is dba in sql? : SQL DBA

1037

what is sql in mysql? : Sql dba

1185

Explain what is a database?

1081

How to display the current date in sql?

1070

What are the properties of a transaction?

1128

how to convert character strings to numeric values? : Sql dba

1102

What sql does db2 use?

974

Cite the differences between execution of triggers and stored procedures?

1075

What are triggers and its uses?

1042

What is sql basics?

1037

How do you select unique values in sql?

997

What are the parts of a basic sql query?

962

Which data type is a composite type?

985