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
- 9441 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
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
Why does Oracle not permit the use of PCTUSED with indexes?
what is a crs resource?
how can you process messages in order asynchronously?
What would you do with an "in-doubt" distributed transaction?
how can you record information about current session?
What authentication modes does sql server support? : sql server DBA
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?
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
What is a system database and what is a user database? : sql server DBA
Query processing is slow(eg select query)how will u solve that
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
which background process invoke at the time of upgradation tell me???
what is asm?
