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
- 12597 Views
- Fidelity, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
How do I save a stored procedure?
What is spool?
What is a Procedure ?
Are stored procedures faster than dynamic sql?
what is explain plan?, given an example...
Can we join 3 tables in sql?
when MSQL8.0 is in market
What is an intersect?
Can one improve the performance of sql*loader? : aql loader
what is the different between unique+not null & primary key,
how can we replace the particular column value of a resulted set of executed query? I mean write down a sql query to chane the particular column's value of a resulted set of executed query
Can we use having without group by in sql?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
