Home » Developer & Programmer » JDeveloper, Java & XML » dbms_xmlquery
dbms_xmlquery [message #230917] Fri, 13 April 2007 06:01 Go to next message
kevins1966
Messages: 1
Registered: April 2007
Junior Member
In a procedure I do the following.

update MyTable
set statusflag = 'Running'
where statusflag NOT IN ('New', 'Complete');

v_ctx := dbms_xmlquery.newcontext(
'SELECT * FROM MyTable WHERE statusflag = ''Running'''
);

dbms_xmlquery.setrowsettag(v_ctx, 'ROWS');
dbms_xmlquery.setrowtag(v_ctx, 'ROW');
po_xmldoc := dbms_xmlquery.getxml(v_ctx);
dbms_xmlquery.closecontext(v_ctx);


The xml is proving to be empty suggesting no rows are being selected.

Could it be that the two operations are performed in seperate sessions so the second can't pick up records with statii assigned in the update because no commit has happened.

If so what is the work around so I don't have to use a commit?

Thanks
Re: dbms_xmlquery [message #231016 is a reply to message #230917] Fri, 13 April 2007 12:50 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Maybe a stupid question, but you are sure your update did in fact set rows to Running?
Previous Topic: error message when attempting to email report
Next Topic: ADF PROBLEM: Unable to create application module
Goto Forum:
  


Current Time: Mon Dec 05 19:26:07 CST 2016

Total time taken to generate the page: 0.13349 seconds