| dbms_xmlquery [message #230917] |
Fri, 13 April 2007 06:01  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
