I'm running into ORA-06512 issue when attempting to output a XML data. Can you please help?
create table test2 (
pk number,
year varchar2(4),
entity varchar2(100),
state varchar2(10),
country varchar2(50)
);
insert into test2
select rownum, to_char(sysdate, 'YYYY'), 'E'||rownum, 'S'||(rownum+2)*2, 'USA'
from dual
connect by rownum<=500;
select * from test2;
declare
l_xmltype xmltype;
v_clob clob;
begin
dbms_output.enable(1000000);
l_xmltype := dbms_xmlgen.getxmltype('SELECT * from test2' );
dbms_output.put_line(l_xmltype.getclobval);
end;
/
Thanks
Message was edited by: User528456-OC