You have just compiled a PL/SQL package but got errors, how
would you view the errors?
- 3 Answers
- 8893 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the importance of a recovery model? : sql server DBA
how can a session indicate its interest in receiving alerts?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
when does an alert gets signaled?
What is the difference between dropping a database and taking a database offline? : sql server DBA
What purpose does the model database server? : sql server DBA
what is a user-defined lock?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What types of replication are supported in sql server? : sql server DBA
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
how can you schedule a job in database?
Explain about your sql server dba experience? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
