Question regarding DECLARE statement

[dlingo]

I have two seperate Oracle 8i environments that I am working in. In my development environment, I wrote a stored procedure (package body) that compiles without problems. However, in the operational environment, the same package body is returning the following compilation error:

PLS-00201: identifier DBMS_XMLQuery.ctxType must be declared

Here is the procedure that is generating the error:

PROCEDURE import(
v2_table_prefix_i in varchar2,
v2_file_name_i in varchar2,
v2_dir_name_i varchar2 := ''
)

IS
Ctx DBMS_XMLQuery.ctxType; -- Var's to convert SQL output to XML

BEGIN
Ctx := DBMS_XMLQuery.newContext('SELECT * FROM emp WHERE empno = :empno');

END import;

If anyone can help me understand why the two different environments would be acting differently and what I can do to fix the package body or change the database settings between the two different enviorments, I would be greatful. Thanks in advance.

 

[LKBrwnDBA]

I believe 8i does not have XML support.

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb