Anyone got any thoughts on this? This is Sun and 8.1.7.4. I installed Java and xml but the developer is still having problems. Metalink has very little to offer. _____ From: Cramer, John To: Michael Kline Subject: RE: xml in Oracle8 I think we're getting very close. I can see all the xml related packages now in Sys and they even have nice intellisense popping up in TOAD. But it looks like it can't find where some java classes are installed. I included 2 examples; I tried to use the DBMS_XMLQuery package and the XMLGen package, but both got an error below from a java class. I checked the javains1.log file, and found those class names all over the place, so I guess they are there somewhere, maybe it's just not finding them?? When I run this: declare queryCtx DBMS_XMLQuery.ctxType; result clob; begin DBMS_JAVA.set_output (1000000); dbms_output.put_line('here1'); queryCtx := DBMS_XMLQuery.newContext('select 1 from dual'); dbms_output.put_line('here2'); result := DBMS_XMLQuery.getXML(queryCtx); DBMS_XMLQuery.closeContext(queryCtx); exception when others then dbms_output.put_line(substr(sqlerrm,1,255)); end; I get this DBMS_OUTPUT: here1 ORA-29540: class oracle/xml/sql/query/OracleXMLStaticQuery does not exist When I run this: declare queryCtx varchar2(20); result clob; begin DBMS_JAVA.set_output (1000000); queryCtx := 'select 1 from dual'; dbms_output.put_line('here1'); result := XMLGen.getXML(queryCtx); dbms_output.put_line('here2'); exception when others then dbms_output.put_line(substr(sqlerrm,1,255)); end; I get this DBMS_OUTPUT: here1 ORA-29540: class OracleXMLStore does not exist -- //www.freelists.org/webpage/oracle-l