>sqlplus.exe
Enter user-name: SYSTEM
[...]
SQL> exec dbms_output.enable;
PL/SQL procedure successfully completed.
SQL> set serveroutput on size 10000;
SQL> exec dbms_output.put_line('1');
1
1
PL/SQL procedure successfully completed.
Oracle - Package reRun
Код:
После выполнения
Код:
SQL> @d:\oracle\ora90\rdbms\admin\dbmsotpt
Package created.
Synonym created.
Grant succeeded.
Package created.
Synonym created.
Grant succeeded.
пакет переходит в нерабочее состояние:
Код:
SQL> exec dbms_output.put_line('1');
ERROR:
ORA-04068: existing state of packages has been discarded
ORA-04067: not executed, package body "SYSTEM.DBMS_OUTPUT" does not exist
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
ERROR:
ORA-04068: existing state of packages has been discarded
ORA-04067: not executed, package body "SYSTEM.DBMS_OUTPUT" does not exist
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
Объясните плз (желательно командой sqlplus) кто сколько может как скомпилить после такого пакет в рабочее состояние.
[help]
Всем спасибо, вопрос снят.