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

What is scalar function?

998

What is cross join sql?

862

how to present a past time in hours, minutes and seconds? : Sql dba

942

Explain foreign key in sql?

968

how mysql optimizes distinct? : Sql dba

999

What is delete command in sql?

1050

What is the use of sqlerrd 3?

889

What is the difference between an inner join and an outer join?

966

Explain aggregate functions are available there in sql?

938

What is hibernate and its relation to sql?

1064

Is pl sql different from sql?

931

List the various privileges that a user can grant to another user?

987

What is out parameter used for eventhough return statement can also be used in pl/sql?

1013

can sql servers linked to other servers like oracle? : Sql dba

949

What do you mean by field in sql?

1033