Interested to Buy Any Domain ? << Click Here >> for more details...
You have just compiled a PL/SQL package but got errors, how
would you view the errors?
- 3 Answers
- 9503 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 spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
How do you open a cluster administrator? : sql server DBA
What purpose does the model database server? : sql server DBA
who owns the operating system files created by the utl_file package?
How would you extract DDL of a table without using a GUI tool?
Where do you find the default index fill factor and how to change it? : sql server DBA
What is the default fill factor value? : sql server DBA
Why would you call update statistics? : sql server DBA
how can you initialize log miner?
what is asm?
what are the differences of where and if in SAS?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
