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
- 9494 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 do you resize a data file?
How many memory layers are in the shared pool?
How do you trace the traffic hitting a sql server? : sql server DBA
how can you implement fine-grained auditing?
What's the benefit of "dbms_stats" over "analyze"?
How can you enable a trace for a session?
How to make a replica of existing oracle server to another server?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
how can a session indicate its interest in receiving alerts?
Explain about your sql server dba experience? : sql server DBA
What is the default fill factor value? : sql server DBA
who owns the operating system files created by the utl_file package?
-
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)
