Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PLS-00201: identifier 'DBMS_XMLSCHEMA.REGISTERSCHEMA' must be declared

291354Nov 20 2003 — edited Jul 14 2006

Windows NT 4.0, Oracle 9.2.0.4 (interim patchset 3160576)

After upgrading to 9.2.0.4 and installing interim patchset 3160576 (apparently successfully), a developer is seeing this message when attempting to run this script to register a schema:

declare
xbfile BFILE;
xclob CLOB;
BEGIN
xbfile := bfilename('DATAHOME_FINAID','CommonRecord2.0c-VR.xsd');
DBMS_LOB.OPEN(xbfile);
DBMS_LOB.CREATETEMPORARY(xclob,TRUE,DBMS_LOB.SESSION);
DBMS_LOB.LOADFROMFILE(xclob,xbfile, DBMS_LOB.GETLENGTH(xbfile));
DBMS_LOB.CLOSE(xbfile);
dbms_xmlschema.registerSchema
(
'CommonRecord2.0c-VR.xsd',
xclob,
FALSE,TRUE,FALSE,TRUE
);
end;
/

SQL> /
dbms_xmlschema.registerSchema
*
ERROR at line 10:
ORA-06550: line 10, column 6:
PLS-00201: identifier 'DBMS_XMLSCHEMA.REGISTERSCHEMA' must be declared
ORA-06550: line 10, column 6:
PL/SQL: Statement ignored

I assume that something went awry when they upgraded and installed the patch, but I'm not a DBA and don't have a clue.

Can anyone suggest a fix?

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 11 2006

Added on Nov 20 2003

#performance-availability, #xml-db

10 comments

5,451 views