PLS-00306: wrong number or types of arguments in call to 'VALUEOF' when accessing xslprocessor or dbms_xslprocessor (Doc ID 943152.1)

Last updated on JULY 18, 2012

Applies to:

Oracle Server - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.

Symptoms

XDB.DBMS_XSLPROCESSOR package body is INVALID and recompiling it fails with these errors:

SQL> alter package DBMS_XSLPROCESSOR compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY DBMS_XSLPROCESSOR:

LINE/COL ERROR
-------- -----------------------------------------------------------------
1044/3   PL/SQL: Statement ignored
1044/3   PLS-00306: wrong number or types of arguments in call to 'VALUEOF'

Or XDB.DBMS_XSLPROCESSOR is VALID but calling xslprocessor.valueof under a non-XDB schema fails with the same PLS-00306 error:

SQL> conn apps/apps
SQL> declare
  2   commitNode  xmldom.DOMNode;
  3   attributeName  VARCHAR2(4000);
  4   l_varchar2 VARCHAR2(4000);
  5  begin
  6   dbms_output.put_line('1');
  7   l_varchar2 := xslprocessor.valueof(commitNode,attributeName);
  8   dbms_output.put_line('2');
  9  end;
 10  /
l_varchar2 := xslprocessor.valueof(commitNode,attributeName);
              *
ERROR at line 7:
ORA-06550: line 7, column 15:
PLS-00306: wrong number or types of arguments in call to 'VALUEOF'
ORA-06550: line 7, column 1:
PL/SQL: Statement ignored

dba_registry shows XDB is VALID:

...
JAVAVM      VALID       10.2.0.4.0  JServer JAVA Virtual Machine
XDB         VALID       10.2.0.4.0  Oracle XML Database
XML         VALID       10.2.0.4.0  Oracle XDK
...

Querying dba_objects shows the existence of old 9i packages XMLDOM, XMLPARSER, and XSLPROCESSOR:

SQL> select owner, object_name, object_type from dba_objects
     where object_name like '%XSLPROCESSOR%'
        or object_name like '%XMLDOM%'
        or object_name like '%XMLPARSER%'
     order by 2,3,1;
  
OWNER      OBJECT_NAME                    OBJECT_TYPE
---------- ------------------------------ -------------------
...
XDB        DBMS_XMLDOM                    PACKAGE
XDB        DBMS_XMLDOM                    PACKAGE BODY
PUBLIC     DBMS_XMLDOM                    SYNONYM
XDB        DBMS_XMLDOM_LIB                LIBRARY
XDB        DBMS_XMLPARSER                 PACKAGE
XDB        DBMS_XMLPARSER                 PACKAGE BODY
PUBLIC     DBMS_XMLPARSER                 SYNONYM
XDB        DBMS_XMLPARSER_LIB             LIBRARY
XDB        DBMS_XSLPROCESSOR              PACKAGE
XDB        DBMS_XSLPROCESSOR              PACKAGE BODY
PUBLIC     DBMS_XSLPROCESSOR              SYNONYM
XDB        DBMS_XSLPROCESSOR_LIB          LIBRARY
XDB        XMLDOM                         PACKAGE
XDB        XMLDOM                         PACKAGE BODY
PUBLIC     XMLDOM                         SYNONYM
SYS        XMLDOM                         SYNONYM
XDB        XMLDOMIMPLCOVER                PACKAGE
XDB        XMLPARSER                      PACKAGE
XDB        XMLPARSER                      PACKAGE BODY
PUBLIC     XMLPARSER                      SYNONYM
SYS        XMLPARSER                      SYNONYM
XDB        XMLPARSERCOVER                 PACKAGE
XDB        XSLPROCESSOR                   PACKAGE
XDB        XSLPROCESSOR                   PACKAGE BODY
SYS        XSLPROCESSOR                   SYNONYM
PUBLIC     XSLPROCESSOR                   SYNONYM
XDB        XSLPROCESSORCOVER              PACKAGE

or

OWNER      OBJECT_NAME                    OBJECT_TYPE
---------- ------------------------------ -------------------
...
XDB        DBMS_XMLDOM                    PACKAGE
XDB        DBMS_XMLDOM                    PACKAGE BODY
PUBLIC     DBMS_XMLDOM                    SYNONYM
XDB        DBMS_XMLDOM_LIB                LIBRARY
XDB        DBMS_XMLPARSER                 PACKAGE
XDB        DBMS_XMLPARSER                 PACKAGE BODY
PUBLIC     DBMS_XMLPARSER                 SYNONYM
XDB        DBMS_XMLPARSER_LIB             LIBRARY
XDB        DBMS_XSLPROCESSOR              PACKAGE
XDB        DBMS_XSLPROCESSOR              PACKAGE BODY
PUBLIC     DBMS_XSLPROCESSOR              SYNONYM
XDB        DBMS_XSLPROCESSOR_LIB          LIBRARY
APPS       XMLDOM                         PACKAGE
APPS       XMLDOM                         PACKAGE BODY
PUBLIC     XMLDOM                         SYNONYM
SYS        XMLDOM                         SYNONYM
APPS       XMLDOMIMPLCOVER                PACKAGE
APPS       XMLPARSER                      PACKAGE
APPS       XMLPARSER                      PACKAGE BODY
PUBLIC     XMLPARSER                      SYNONYM
SYS        XMLPARSER                      SYNONYM
APPS       XMLPARSERCOVER                 PACKAGE
APPS       XSLPROCESSOR                   SYNONYM
PUBLIC     XSLPROCESSOR                   SYNONYM
SYS        XSLPROCESSOR                   SYNONYM
APPS       XSLPROCESSORCOVER              PACKAGE

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms