You have just compiled a PL/SQL package but got errors, how
would you view the errors?

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


Please Help Members By Posting Answers For Below Questions

what functionality does oracle provide to secure sensitive information?

552


what are the types of connection load-balancing?

564


What types of replication are supported in sql server? : sql server DBA

597


suppose you want to audit specific activities on sensitive data. How can you achieve that?

547


which background process invoke at the time of upgradation tell me???

2223






Why would you call update statistics? : sql server DBA

577


Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

1844


What is dbcc? : sql server DBA

777


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

3801


Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1511


How can you control the amount of free space in your index pages? : sql server DBA

729


how can you record information about current session?

495


Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

601


what is the last version,the release date of that version and fix pack of ibm db2 udb?

1520


What are statistics, under what circumstances they go out of date, how do you update them?

1804