Hi All,
I am getting issue while trying to see XML results in Oracle SQL Developer. When results set are small I am able see results through DBMS_OUTPUT but getting issue when XML output is big.
My Code;
Declare
l_outputXML CLOB;
Begin
abcd.table_data(p_outputXML => l_outputXML);
dbms_output.put_line('l_outputXML : -'|| nvl(l_outputXMKL,'NULL,));
end;
When xml is returning 50 records I am able to see results in SQL Developer but when query is returning 200 records not able to see results and getting erorr
ORA-06502 : PL/SQL numeric or Value error.
Question, how to see large XML results in Oracle SQL Developer. This is required to debut some results via XML.
Thanks in advance.
Rick