Skip to Main Content

Java EE (Java Enterprise Edition) General Discussion

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

XMLoutput in Apex 5.1

Jadey_apexJul 8 2021 — edited Jul 8 2021

Dear All,
I have a xml query like this:
SELECT XMLELEMENT("SetField",'<SetFieldname="acct_nr">'||''||'rekeningnummer_rec.rekeningnummer'||''||'</SetField>')
,XMLELEMENT("SetField",'<SetField name="agent_nr">'||''||wa_rec.agent_nummer||''||'</SetField>')
,XMLELEMENT("SetField",'<SetField name="cost_code">'||''||'wa_rec.agent_nummer'||''||'</SetField>')
,XMLELEMENT("SetField",'<SetField name="cur_code">'||''||'CASE
when rekeningnummer_rec.tgl_systeem_naam = pva_const_pkg.g_tgl_waprovisiejaar
THEN lc_srd
when rekeningnummer_rec.tgl_systeem_naam = pva_const_pkg.g_tgl_waprovisiejaaragent
then lc_srd
else lc_pseudo_empty_str
end '||''||'</SetField>')
INTO l_wa_xml_data_clob
from dual;

My output in Apex 5.1 is like this:
<SetField name="acct_nr">rekeningnummer_rec.rekeningnummer</SetField><SetField name="agent_nr"></SetField><SetField name="cost_code">wa_rec.agent_nummer</SetField><SetField name="cur_code">CASE when rekeningnummer_rec.tgl_systeem_naam = pva_const_pkg.g_tgl_waprovisiejaar THEN lc_srd when rekeningnummer_rec.tgl_systeem_naam = pva_const_pkg.g_tgl_waprovisiejaaragent then lc_srd else lc_pseudo_empty_str end </SetField>

My problem is that the variables given in bold should be replaced by values which are from cursors.
But instead of that I get no value between the tags.
Can someone help me out with this?
I will be very grateful if someone could help me out with this.
Thanx in advance.

Comments

Srini Chavali-Oracle
It depends - most, if not all, database patches require that the database be shut down. Check the README accompanying each patch.

HTH
Srini
user62721
Hi,

from 11g, some patches are online
$ opatch query -is_online_patch
Regards
Srini Chavali-Oracle
Good stuff ! More details in

Gathering Patch details before applying using Opatch Query option [ID 1510747.1]

HTH
Srini
Osama_Mustafa
including to information posed by other check
RDBMS Online Patching Aka Hot Patching [ID 761111.1
1005886
Thank you guys for helping me in patching
1 - 5

Post Details

Added on Jul 8 2021
0 comments
148 views