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
12609 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

How do I add a database to sql?

1125

Can you have more than one trigger on a table?

1003

Can primary key be changed?

905

What is the least restrictive isolation level? : Transact sql

1068

what are aggregate and scalar functions? : Sql dba

1057

What are the different types of constraints?

1186

Is sql dba a good career? : SQL DBA

991

Is pl sql useful?

992

What is cursor status?

1186

What is rtm stands for?

1098

What is triggering circuit?

1064

what is a constraint? : Sql dba

1168

what is sub-query? : Transact sql

1102

How do rank () and dense_rank () differ?

1044

What are crud methods?

1036