Menu de navegação

[GilvaneParticipante]

Boa tarde.

Criei uma tabela com o nome de NFE_AUTO_XML, possuindo os seguintes campos: (COD_EMPRESA number(3), DSC_CAMPO_XML sys.xmltype).

Para inserir registros, utilizo a seguinte instrução: INSERT INTO NFE_AUTO_XML VALUES (1, xmltype (dbms_xslprocessor.read2clob (‘D:ORACLETXT’, ‘MeuAquivo.xml’)));

Tenho 2 máquinas em meu escritório, ambas com Oracle 9.2 e apenas em uma das máquinas, quando executo essa instrução, ocorre o seguinte erro:
ORA-22800: tipo definido pelo usuário inválido

EXISTE UM Package com o nome de “createXML” que diz estar inválido, com a seguinte mensagem:
[b]PLS-00201: o identificador ‘XMLTYPE_LIB’ deve ser declarado
PL/SQL: Compilation unit analysis terminated[/b]

Este package pelo que pude perceber, é criado diretamente pelo Oracle e tem o seguinte conteúdo:
********************************************************
type xmltype authid current_user as opaque varying (*)
using library sys.xmltype_lib
(
— creates the XML data
static function createXML (xmlData IN clob) return sys.XMLType deterministic,
static function createXML (xmlData IN varchar2) return sys.XMLType deterministic,
— extract function
member function extract(xpath IN varchar2) return sys.XMLType deterministic,
— existsNode function
member function existsNode(xpath IN varchar2) return number deterministic,
— is it a fragment?
member function isFragment return number deterministic,
— extraction functions..!
— do we want the encoding to be specified in the result or not ..?
member function getClobVal return CLOB deterministic,
member function getStringVal return varchar2 deterministic,
member function getNumberVal return number deterministic,
— FUNCTIONS NEW IN 9iR2
— new versions of createxml
STATIC FUNCTION createXML (xmlData IN clob, schema IN varchar2,
validated IN number := 0, wellformed IN number := 0)
return sys.XMLType deterministic,
STATIC FUNCTION createXML (xmlData IN varchar2, schema IN varchar2,
validated IN number := 0, wellformed IN number := 0)
return sys.XMLType deterministic,
STATIC FUNCTION createXML (xmlData IN ““,
schema IN varchar2 := NULL, element IN varchar2 := NULL,
validated IN NUMBER := 0)
return sys.XMLType deterministic,
STATIC FUNCTION createXML (xmlData IN SYS_REFCURSOR,
schema in varchar2 := NULL, element in varchar2 := NULL,
validated in number := 0)
return sys.XMLType deterministic,
— new versions of extract and existsnode with nsmap
MEMBER FUNCTION extract(xpath IN varchar2, nsmap IN VARCHAR2)
return sys.XMLType deterministic,
MEMBER FUNCTION existsNode(xpath in varchar2, nsmap in varchar2)
return number deterministic,
— transform function
member function transform(xsl IN sys.XMLType,
parammap in varchar2 := NULL)
return sys.XMLType deterministic,
— conversion functions
MEMBER PROCEDURE toObject(SELF in sys.XMLType, object OUT ““,
schema in varchar2 := NULL,
element in varchar2 := NULL),
— schema related functions
MEMBER FUNCTION isSchemaBased return number deterministic,
MEMBER FUNCTION getSchemaURL return varchar2 deterministic,
MEMBER FUNCTION getRootElement return varchar2 deterministic,
— create schema and nonschema based
MEMBER FUNCTION createSchemaBasedXML(schema IN varchar2 := NULL)
return sys.XMLType deterministic,
— creates a non schema based document from self
MEMBER FUNCTION createNonSchemaBasedXML return sys.XMLType deterministic,
member function getNamespace return varchar2 deterministic,
— validates schema based document if VALIDATED flag is false
member procedure schemaValidate(self IN OUT NOCOPY XMLType),
— returns the value of the VALIDATED flag of the document; tells if
— a schema based doc. has been actually validated against its schema.
member function isSchemaValidated return NUMBER deterministic,
— sets the VALIDATED flag to user desired value
member procedure setSchemaValidated(self IN OUT NOCOPY XMLType,
flag IN BINARY_INTEGER := 1),
— checks if doc is conformant to a specified schema; non mutating
member function isSchemaValid(schurl IN VARCHAR2 := NULL,
elem IN VARCHAR2 := NULL) return NUMBER deterministic,
— constructors
constructor function XMLType(xmlData IN clob, schema IN varchar2 := NULL,
validated IN number := 0, wellformed IN number := 0)
return self as result deterministic,
constructor function XMLType(xmlData IN varchar2, schema IN varchar2 := NULL
, validated IN number := 0, wellformed IN number := 0)
return self as result deterministic,
constructor function XMLType (xmlData IN ““,
schema IN varchar2 := NULL, element IN varchar2 := NULL,
validated IN number := 0)
return self as result deterministic,
constructor function XMLType(xmlData IN SYS_REFCURSOR,
schema in varchar2 := NULL, element in varchar2 := NULL,
validated in number := 0)
return self as result deterministic
)dbms_output.put_line(‘dbms_output.put_line(‘ ‘); ‘);
********************************************************

Alguém poderia me ajudar para a solução para esse problema?

Obrigado.

[diegolenhardtParticipante]

O que retorna na consulta abaixo na base que não funciona…

select status
from dba_registry
where comp_id = ‘XML’

VALID ?

[GilvaneParticipante]

Retorna: VALID

[Autor]

Posts