abstract:
'<test><something>some value</something></test>';
dbms_lob.writeappend(
lob_loc => p_xml,
amount => length(lv_xml),
buffer => lv_xml
);
end p_xml_test_2;
I'm wondering if the first method will cause any problems for me down the road. Is it ok to do it that way? What is the advantage, if any, to the second method? Thanks!
I would like to create some PL/SQL procedures that return XML as CLOB parameters. I want to just do this (which works fine with simple tests):
Code:- create or replace procedure p_xml_test_1(
- p_xml out nocopy clob
- ) is
- begin
- p_xml := '<?xml version="1.0" encoding="utf8" ?>' ||
- '<test><something>some value</something></test>';
- end p_xml_test_1;
Code:- create or replace procedure p_xml_test_2(
- p_xml out nocopy clob
- ) is
- lv_xml clob;
- begin
- dbms_lob.createtemporary(
- lob_loc => p_xml,
- cache => true
- );
- lv_xml := '<?xml version="1.0" encoding="utf8" ?>' ||
- '<test><something>some value</something></test>';
- dbms_lob.writeappend(
- lob_loc => p_xml,
- amount => length(lv_xml),
- buffer => lv_xml
- );
- end p_xml_test_2;
|
