Архив форумов ЦИТФорума

[wjvik]

Помогите разобраться. При попытке использовать xmlType в xsql странице выдается:

Oracle XML Developers Kit 10.1.3.1.0 - Production
XML-25017: ???????? ?????????????? ??????
oracle.classloader.util.AnnotatedNoClassDefFoundError:

????????????? ?????: oracle.xdb.XMLType

????????? ?????: oracle.xml.sql.core.OracleXMLConvert
?????????: oracle.xml:10.1.0_2
???????? ???: /C:/oracle/AS10.1.3/LIB/xsu12.jar
????????????: <code-source> (ignore manifest Class-Path) in META-INF/boot.xml in C:\oracle\AS10.1.3\j2ee\home\oc4j.jar

????????????? ????? ?? ???????? ?? ? ????? ???????? ???? ??? ?????????? ? ???????.
at oracle.classloader.PolicyClassLoader.handleClassNotFound (PolicyClassLoader.java:2068) [/C:/oracle/AS10.1.3/j2ee/home/lib/pcl.jar (from system property java.class.path), by sun.misc.Launcher$AppClassLoader@12700959]


пример программ:
<?xml version="1.0"?>
<catalog_piece connection="ююююююю" xmlns:xsql="urn:oracle-xsql">
<xsql:query>
select TEST_XML({@ccc}) as tt from dual
</xsql:query>
</catalog_piece>


FUNCTION TEST_XML( rows_count IN number DEFAULT 0) RETURN xmlType
IS
buf CLOB;
str varchar2(1000);
BEGIN
dbms_lob.createtemporary( buf, true);
str :='<ert>';
dbms_lob.writeappend( buf, length(str), str);
FOR j IN 1..rows_count LOOP
str :='<wertwergwerert num="'||to_char(j)||'" erty="sdfg" ertyy="sadfgsdsdfg" dfbkjsdfb="sdfbsdfgbsdfbsdf" />';
dbms_lob.writeappend( buf, length(str), str);
END LOOP;
str :='</ert>';
dbms_lob.writeappend( buf, length(str), str);
RETURN xmlType('<ert><rty/></ert>');
END;