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

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

Question Posted / guest

3 Answers
9467 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / priya reddy

show error;
This is the command used to view the errors..

Is This Answer Correct ?

3 Yes

1 No

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

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

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

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

Post New Answer

More DB Administration Interview Questions

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers IBM,

deleted of control file how will u recover control file?

4 Answers CTS,

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

0 Answers

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

0 Answers

What are the different ways you can create databases in sql server? : sql server DBA

0 Answers

What the different components in replication and what is their use? : sql server DBA

0 Answers

What is replication? : sql server DBA

0 Answers

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

0 Answers HSBC,

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers Patni,

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers Oracle,

For more DB Administration Interview Questions Click Here