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

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

0 Answers IBM,

what are the differences of where and if in SAS?

0 Answers

How do you trace the traffic hitting a sql server? : sql server DBA

0 Answers

What background process refreshes materialized views?

2 Answers Accenture, FLSmidth,

hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table

3 Answers IBM,

Can you redefine a table online?

0 Answers Oracle,

I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

1 Answers

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

0 Answers

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

0 Answers

what do you understand by fine-grained auditing?

0 Answers Oracle,

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers

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

0 Answers

For more DB Administration Interview Questions Click Here