Home » Developer & Programmer » JDeveloper, Java & XML » DBMS_XML gen issue (Oracle 9i)
DBMS_XML gen issue [message #386677] Mon, 16 February 2009 10:03
Messages: 1
Registered: February 2009
Junior Member
Hello All,

I am trying to execute this procedure
create or replace procedure insProc is
Cursor C1 is select data from test_stage_I;
insCtx DBMS_XMLSave.ctxType;
rows number;
insCtx := DBMS_XMLSave.newContext('ace_data'); -- get the context handle
Dbms_Xmlsave.setDateFormat(insCtx, 'dd/MM/yyyy');
for I in C1
rows := DBMS_XMLSave.insertXML(insCtx,I.data); -- this inserts the document
end loop;
DBMS_XMLSave.closeContext(insCtx); -- this closes the handle

I am able to execute this in the schema that is based on 10g...but not in the one with 9i...it throws the following error :
ORA-29532 : Java call terminated by uncaught Java exception....
Character '$' is not allowed in an XML tag name.
Previous Topic: Deployment Application To Weblogic Server Failed
Next Topic: Problems while loading JSSE Java classes into Oracle 9i
Goto Forum:

Current Time: Tue Sep 26 20:10:48 CDT 2023