Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 12581 Views
- Fidelity, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How can a function retun more than one value in oracle with proper example?
How to use sql*plus built-in timers?
What are the advantages of stored procedure?
What are the two characteristics of a primary key?
how to enter numeric values as hex numbers? : Sql dba
What is the plv (pl/vision) package offers?
what are the advantages a stored procedure? : Sql dba
Which kind of parameters cannot have a default value in pl sql?
Are dml statements autocommit?
what is the use of set statement in tsql? : Transact sql
How do you write a complex sql query?
What is scalar function?
Is null operator in sql?
how to load data files into tables with 'mysqlimport'? : Sql dba
what is the difference between a local and a global temporary table? : Sql dba
