Home » Developer & Programmer » JDeveloper, Java & XML » dbms_xmlquery
dbms_xmlquery [message #230917] Fri, 13 April 2007 06:01 Go to next message
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);

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?

Re: dbms_xmlquery [message #231016 is a reply to message #230917] Fri, 13 April 2007 12:50 Go to previous message
Messages: 7897
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: Wed Feb 01 09:01:50 CST 2023