package fails first time after changes
96429Oct 7 2004 — edited Oct 8 2004Hi,
I have a package that I am making changes to. I'm running the package via the SQL Plus Worksheet. After making the changes to the package and recompiling, I try to execute the program from SQL Plus Worksheet and get this error message:
BEGIN xml_import_export_package2_NED.start_transfer(:v_error_no, :v_error_message,:v_error_procedure); END;
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of package "AVENTISDM.XML_IMPORT_EXPORT_PACKAGE2_NED" has been invalidated
ORA-04065: not executed, altered or dropped package "AVENTISDM.XML_IMPORT_EXPORT_PACKAGE2_NED"
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
The package does not run. However, when I execute it again it works fine. I'm now concerned that if I make a change to a package during the day, that is scheduled to run at night, that it will fail unless I run it once first.
Is this behaviour by design?
Regards,
Ned