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 MARCH 28, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.1 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A 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'
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
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
...
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
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
---------- ------------------------------ -------------------
...
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |