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
9370 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

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers

What is RAID and what are different types of RAID configurations?

1 Answers

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

0 Answers

what is the use of ocr?

0 Answers Oracle,

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

0 Answers Infosys,

Give the reasoning behind using an index.

2 Answers

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers

Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?

1 Answers

What is the difference between online backup & offline backup?

3 Answers CSC,

now one user in online.now i want drop him..how do u drop him?

4 Answers Wipro,

Explain the use of table functions.

1 Answers

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers

For more DB Administration Interview Questions Click Here