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

Difference between SUBSTR and INSTR?

3 Answers  

Explain the purpose of %type and %rowtype data types?

0 Answers  

What are all the different types of indexes?

0 Answers  

what are the methods using performance tunning in sql and pl/sql

2 Answers  

How many indexes can be created on a table in sql?

0 Answers  

Is join and inner join the same?

0 Answers  

How to call shell script from pl sql procedure?

0 Answers  

What is the result, when NULL is compared with NULL?

22 Answers   TCS,

What is the limitation on the block size of pl/sql?

0 Answers  

What is raid? How does it help storage of databases?

0 Answers  

Difference between IN and EXISTS

4 Answers   Nous, Polaris,

What are the different types of triggers?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories