Interested to Buy Any Domain ? << Click Here >> for more details...
How to trace the errors in pl/sql block code?
- 5 Answers
- 16377 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / madhuri
SHOW ERROR will show the error code and message in a pl/sql
block.
If you know where exactly the error is then uses number of
dbms statements before/after each sql statement.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is #table in sql?
How do I write a cron which will run a sql query and mail the results to agroup?
what are the types of join and explain each? : Sql dba
What is data type in database?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
Can 2 queries be executed simultaneously in a distributed database system?
Why should I use postgresql?
What are user defined functions?
what is auto increment? : Sql dba
Name some usages of database trigger?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
what are the differences between require and include, include_once and require_once? : Sql dba
what is the difference between blob and text? : Sql dba
how to use myisamchk to check or repair myisam tables? : Sql dba
what is sub-query? : Transact sql
