You have just compiled a PL/SQL package but got errors, how
would you view the errors?
- 3 Answers
- 8885 Views
- I also Faced
- E-Mail Answers
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 differences of where and if in SAS?
What are the different ways you can create databases in sql server? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
Why would you call update statistics? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What is the importance of a recovery model? : sql server DBA
What is the difference between dropping a database and taking a database offline? : sql server DBA
what are the types of connection load-balancing?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
How do you trace the traffic hitting a sql server? : sql server DBA
What authentication modes does sql server support? : sql server DBA
suppose you want to audit specific activities on sensitive data. How can you achieve that?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
how can you enable flashback feature?
