Janet,
The Show Errors command is only good if you were to reload the package from
disk. Maybe if you did an alter package compile. Since you did neither,
this command does not help you.
Your other problem could be caused by the package being executed by someone
while you were trying to
Janet,
The last place where I worked, we had to split a big package into smaller
ones since we hit a # of lines limit (undocumented!).
Prakash
-Original Message-
Sent: Thursday, September 05, 2002 5:58 PM
To: Multiple recipients of list ORACLE-L
Hi all,
I have couple of questions,
-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: couple of questions ???
Date: Fri, 06 Sep 2002 11:58:29 -0800
Janet,
The last place where I worked, we had to split a big package into smaller
ones since we hit a # of lines limit (undocumented
Janet,
Your recompile requires taking a lock on all referenced objects.
( A share lock I think. A definite answer requires RTFM )
I would guess that your recompile is waiting on a lock.
Jared
Janet Linsy [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
09/05/2002 02:58 PM
Please respond
Check for Remote DB Link and connection to that DB if any.
Check for the LOCKS.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 05, 2002 02:58 PM
Hi all,
I have couple of questions, 817 on NT.
1. There is an invalid
On Thu, 22 Mar 2001,Donald Bricker scribbled on the wall in glitter crayon:
-Is anyone running Oracle 8.1.6 on Solaris 8? Any problems? Anything to be aware of?
yup, no problems so far. however this is not a large database nor mission
critical. YMMV.;-)
--
Bill Thater
Also for those who have Oracle certification how much database experience
(Oracle in particular) did you have before you obtained certification?
What do you recommend for experience before attempting certification?
OCP and Good Oracle DBA are not one of the same things. There might
be people
True, but it probably looks good on a resume!
-Original Message-
Dandekar
Sent: Thursday, March 22, 2001 11:02 AM
To: Multiple recipients of list ORACLE-L
Also for those who have Oracle certification how much database experience
(Oracle in particular) did you have before you obtained