Home » Developer & Programmer » JDeveloper, Java & XML » DBMS_XML gen issue (Oracle 9i)
DBMS_XML gen issue [message #386677] Mon, 16 February 2009 10:03
n_kp_2000
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;
begin
insCtx := DBMS_XMLSave.newContext('ace_data'); -- get the context handle
Dbms_Xmlsave.setDateFormat(insCtx, 'dd/MM/yyyy');
for I in C1
loop
rows := DBMS_XMLSave.insertXML(insCtx,I.data); -- this inserts the document
end loop;
DBMS_XMLSave.closeContext(insCtx); -- this closes the handle
end;

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: Sun Apr 20 12:47:42 CDT 2014

Total time taken to generate the page: 0.07939 seconds