You have just compiled a PL/SQL package but got errors, how
would you view the errors?
Answer Posted / 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 |
Post New Answer View All Answers
How would you extract DDL of a table without using a GUI tool?
what is asm?
how can you get actual data change values from previous transactions in oracle?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
Explain about your sql server dba experience? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
Explain materialized views and how they are used.
How would you go about verifying the network name that the local_listener is currently using?
What is replication? : sql server DBA
How do you open a cluster administrator? : sql server DBA
What is the difference between dropping a database and taking a database offline? : sql server DBA
how can you record information about current session?