Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Compiling Packages (PL/SQL Developer)
Compiling Packages [message #465466] Wed, 14 July 2010 04:53 Go to next message
dev_777
Messages: 32
Registered: June 2010
Member
I compile packages using PL Sql Developer. After compiling the package, a user goes into an Oracle form that uses the package and an error appears ie. 'ORA-04061:existing state of package has been invalidated: ORA-04065: not executed....."

After the user comes out of the form and re-enters the form, they can continue capturing.

Is there any way of compiling packages so that users don't get this error when they first go into the form?

Re: Compiling Packages [message #465477 is a reply to message #465466] Wed, 14 July 2010 05:28 Go to previous messageGo to next message
Michel Cadot
Messages: 67146
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Is there any way of compiling packages so that users don't get this error when they first go into the form?

No unless they disconnect.
Why do you recompile a package when people are working? This should be made ONLY during maintenance window.

Regards
Michel
Re: Compiling Packages [message #465486 is a reply to message #465477] Wed, 14 July 2010 06:03 Go to previous messageGo to next message
dev_777
Messages: 32
Registered: June 2010
Member
Thanks Michel.

For minor changes we normally get the users to log off the application and then compile the package. They don't disconnect Sad
Re: Compiling Packages [message #465498 is a reply to message #465486] Wed, 14 July 2010 06:49 Go to previous message
Littlefoot
Messages: 21562
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What is (from your point of view) difference between "log off the application" and "disconnect"? Aren't they the same?
Previous Topic: migration of table along with data
Next Topic: Access Authentication and Authorization
Goto Forum:
  


Current Time: Tue Jun 02 00:54:47 CDT 2020