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

What is a Mapplet?

0 Answers   Informatica,

What is difference between group by and partition by?

0 Answers  

How can I get the number of records affected by a stored procedure?

0 Answers  

What is the usage of NVL?

7 Answers   Infosys, Micro Infotek,

Types of indexes. What is the default key created when a primary key is created in a table ?

5 Answers   TCS,

What information is needed to connect sql*plus an oracle server?

0 Answers  

How well can multiple sessions access the same data simultaneously ?

1 Answers   Oracle,

How do you use collections in procedure to return the resultset?

0 Answers  

What is Collation Sensitivity ? What are the various type ?

0 Answers  

What is rename command in sql?

0 Answers  

How do I view output in sql developer?

0 Answers  

Can we join more than 2 tables in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories