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 the use of prepared statement?

0 Answers  

What is a rank in sql?

0 Answers  

How many postgresql users are there, worldwide?

0 Answers  

what is sql? : Sql dba

0 Answers  

Explain the methods used to protect source code of pl/sql.

0 Answers  

What is a clob in sql?

0 Answers  

What are the query optimization techniques?

0 Answers  

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

0 Answers  

Explain aggregate functions are available there in sql?

0 Answers  

What are the advantages of sql? Explain

0 Answers  

what is an alias command? : Sql dba

0 Answers  

Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --

5 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories