Interested to Buy Any Domain ? << Click Here >> for more details...
You have just compiled a PL/SQL package but got errors, how
would you view the errors?
- 3 Answers
- 9499 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / priya reddy
show error;
This is the command used to view the errors..
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / santo
Sometimes 'Show error' won't display the required
info...then check dba_errors table
select text from dba_errors where name='****';
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / santosh
show error package <package name>
to check the compilation errors
similarly for functions
show error function <function name>
and for procedures
show error procedure <procedure name>
| Is This Answer Correct ? | 0 Yes | 0 No |
how can you find out if a table can be redefined?
what do you understand by fine-grained auditing?
who owns the operating system files created by the utl_file package?
What is the difference between dropping a database and taking a database offline? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
which background process invoke at the time of upgradation tell me???
Hot backup procedure?
How would you determine the time zone under which a database was operating?
How can you control the amount of free space in your index pages? : sql server DBA
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How can we see the database version in os level
What are the operating modes in which database mirroring runs? : sql server DBA
-
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)
