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 is dbcc? : sql server DBA
How do you open a cluster administrator? : 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 you get actual data change values from previous transactions in oracle?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
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 is the last version,the release date of that version and fix pack of ibm db2 udb?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
How would you go about verifying the network name that the local_listener is currently using?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA