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
- 9445 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / priya reddy
show error;
This is the command used to view the errors..
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / 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 |
Answer / 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 |
Can you redefine a table online?
How do you open a cluster administrator? : sql server DBA
What is the difference between clustered and non-clustered index? : sql server DBA
how can you communicate with operating system files from oracle?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
If we issue alter database begin backup. What happens to database?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
Explain about your sql server dba experience? : sql server DBA
what is difference between user managed backup and rman backup?
now one user in online.now i want drop him..how do u drop him?
What is the difference between the SQL Loader and IMPORT utilities?
How does Oracle guarantee data integrity of data changes?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
