How to trace the errors in pl/sql block code?
Answer Posted / swapna
User_Errors table
OR
show error on sql promt.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
How can you get sql*loader to commit only at the end of the load file? : aql loader
What are inner and outer joins examples of both?
How run sql*plus commands that are stored in a local file?
tell me about various levels of constraint. : Sql dba
What is scalar and vector?
What is the difference between sql and mysql?
How do you add a column to a table?
what is the difference between group by and order by in sql? : Sql dba
What is the purpose of a sql?
Are subqueries better than joins?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
What is sql and db2?
How do I partition in sql?
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
What are different joins used in sql?