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
what are the types of connection load-balancing?
Why would you use sql agent? : sql server DBA
how to restore files with rman?
how can you create a user-defined lock?
What are the steps you will take to improve performance of a poor performing query?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
how can a session indicate its interest in receiving alerts?
how can you get actual data change values from previous transactions in oracle?
What happens on checkpoint? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
what is the use of recording information about current session?