Hi,


das Problem glaube ich ist noch tiefer als ich dachte:( .Ich muss tu sehen wie ich die Package VALID bekomme. siehe auch die Fehlermeldung.



SQL> select * from dba_errors where NAME ='WWV_FLOW_WIZARD_API';

OWNER NAME TYPE SEQUENCE LINE POSITION
------------------------------ ------------------------------ ------------ ---------- ---------- ----------
TEXT
------------------------------------------------------------------------------------------------------------------------
FLOWS_010600 WWV_FLOW_WIZARD_API PACKAGE BODY 1 2864 14
PLS-00905: object FLOWS_010600.WWV_FLOW_WEB_SERVICES is invalid

FLOWS_010600 WWV_FLOW_WIZARD_API PACKAGE BODY 2 2864 5
PL/SQL: Statement ignored


SQL> alter package flows_010600.WWV_FLOW_WEB_SERVICES compile body;

Warning: Package Body altered with compilation errors.

SQL> select * from dba_errors where NAME ='WWV_FLOW_WEB_SERVICES';

OWNER NAME TYPE SEQUENCE LINE POSITION
------------------------------ ------------------------------ ------------ ---------- ---------- ----------
TEXT
------------------------------------------------------------------------------------------------------------------------
FLOWS_010600 WWV_FLOW_WEB_SERVICES PACKAGE 1 9 49
PLS-00201: identifier 'XMLTYPE' must be declared

FLOWS_010600 WWV_FLOW_WEB_SERVICES PACKAGE 2 9 5
PL/SQL: Declaration ignored

FLOWS_010600 WWV_FLOW_WEB_SERVICES PACKAGE 3 174 8
PLS-00201: identifier 'XMLTYPE' must be declared

FLOWS_010600 WWV_FLOW_WEB_SERVICES PACKAGE 4 167 1
PL/SQL: Declaration ignored

FLOWS_010600 WWV_FLOW_WEB_SERVICES PACKAGE BODY 1 1 14
PLS-00905: object FLOWS_010600.WWV_FLOW_WEB_SERVICES is invalid

FLOWS_010600 WWV_FLOW_WEB_SERVICES PACKAGE BODY 2 1 14
PLS-00304: cannot compile body of 'WWV_FLOW_WEB_SERVICES' without its specification

FLOWS_010600 WWV_FLOW_WEB_SERVICES PACKAGE BODY 3 0 0
PL/SQL: Compilation unit analysis terminated


7 rows selected.
SQL>



gruß
htmldbneu