data to xml file DECLARE Ctx DBMS_XMLGEN.ctxHandle;
431974Sep 25 2006 — edited Sep 26 2006Hi all,
I want to export the table data to xml file.
I typed:
SQL> set serveroutput on
SQL> DECLARE
2 Ctx DBMS_XMLGEN.ctxHandle;
3 xml clob;
4 emp_no NUMBER := 7369;
5
6 xmlc varchar2(4000);
7 off integer := 1;
8 len integer := 4000;
9 BEGIN
10 Ctx := DBMS_XMLGEN.newContext('SELECT * FROM emp WHERE empno ='||emp_no);
11 DBMS_XMLGen.setRowsetTag(Ctx, 'EMP_TABLE');
12 DBMS_XMLGen.setRowTag(Ctx, 'EMP_ROW');
13 DBMS_XMLGEN.closeContext(Ctx);
14 xml := DBMS_XMLGEN.getXML(Ctx);
15
16 DBMS_LOB.READ(xml, len, off, xmlc);
17 DBMS_OUTPUT.PUT_LINE(xmlc);
18 END;
19 /
And I got
DECLARE
*
ERROR at line 1:
ORA-19019: Invalid context passed to DBMS_XMLGEN.GETXML
ORA-06512: at "SYS.DBMS_XMLGEN", line 7
ORA-06512: at "SYS.DBMS_XMLGEN", line 147
ORA-06512: at line 14
Any suggestions will be appreciated.
Thank you
aalexsun