Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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 / praveengnr

Answers were Sorted based on User's Feedback



How will you debug your procedure? If your procedure is around 2000 lines and the expected output i..

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

How will you debug your procedure? If your procedure is around 2000 lines and the expected output i..

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

Post New Answer

More SQL PLSQL Interview Questions

How many types of cursors are available in pl/sql?

0 Answers  

how to retrieve only duplicate values in a table

9 Answers  

What is union, minus and interact commands?

0 Answers  

What is the usage of sql functions?

0 Answers  

What are the types of subqueries?

0 Answers  

How do sql triggers work?

0 Answers  

types of exceptions and what is meant by pragma autonomous_transaction ?what is the use.

4 Answers   3i Infotech,

Why we use cross join?

0 Answers  

what is the difernece between named and anonymous pl/sql blocks??

8 Answers   TCS, Wells Fargo,

what is definer rights invoke rights?

1 Answers  

What are advantages of Stored Procedures?

3 Answers   Satyam,

what is the use of double ampersand (&&) in sql queries?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories