Insert into XML TYPE table in Oracle

THE REAL RESULT:
 
 
SQL*Plus: Release 9.2.0.4.0 - Production on Tue Jan 13 14:56:19 2004
 
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
 
SQL> connect xml/xml@test
 
SQL> CREATE TABLE empleados (empid   NUMBER PRIMARY KEY, 
  2                          empname VARCHAR2(30), 
  3                          empjob  VARCHAR2(30), 
  4                          empsal  NUMBER); 
 
Table created.
 
SQL> create or replace procedure InsertXML(xmlDoc IN VARCHAR2, tableName IN VARCHAR2) is 
  2     insCtx DBMS_XMLSave.ctxType; 
  3     rows number; 
  4   begin 
  5      insCtx := DBMS_XMLSave.newContext(tableName); -- get the context handle 
  6      rows := DBMS_XMLSave.insertXML(insCtx,xmlDoc); -- this inserts the document 
  7      dbms_output.put_line(to_char(rows) || ' rows inserted'); 
  8      DBMS_XMLSave.closeContext(insCtx);            -- this closes the handle 
  9  end; 
 10  / 
 
Procedure created.
SQL> exec InsertXML('<?xml version="1.0"?><ROWSET><ROW num="1"><EMPID>10</EMPID><EMPNAME>Perry Smith
</EMPNAME><EMPJOB>Manager</EMPJOB><EMPSAL>800</EMPSAL></ROW><ROW num="1"><EMPID>20</EMPID><EMPNAME>J
ohn Calvach</EMPNAME><EMPJOB>Principal Support Consultant</EMPJOB><EMPSAL>900</EMPSAL></ROW><ROW num
="1"><EMPID>30</EMPID><EMPNAME>Louis Bald</EMPNAME><EMPJOB>Technical Specialist</EMPJOB><EMPSAL>400<
/EMPSAL></ROW><ROW num="1"><EMPID>40</EMPID><EMPNAME>Anthony Flowers</EMPNAME><EMPJOB>Technical Team
 Leader</EMPJOB><EMPSAL>500</EMPSAL></ROW><ROW num="1"><EMPID>50</EMPID><EMPNAME>George Monk</EMPNAM
E><EMPJOB>Support Consultant</EMPJOB><EMPSAL>200</EMPSAL></ROW></ROWSET>','empleados');
 
PL/SQL procedure successfully completed.
 
SQL> select * from empleados;
 
     EMPID EMPNAME                        EMPJOB
---------- ------------------------------ ------------------------------
    EMPSAL
----------
        10 Perry Smith                    Manager
       800
 
        20 John Calvach                   Principal Support Consultant
       900
 
        30 Louis Bald                     Technical Specialist
       400
 
 
     EMPID EMPNAME                        EMPJOB
---------- ------------------------------ ------------------------------
    EMPSAL
----------
        40 Anthony Flowers                Technical Team Leader
       500
 
        50 George Monk                    Support Consultant
       200
 
 
SQL> 
 
 
 
SQL> select SYS_XMLGEN(empid) FROM empleados;
 
SYS_XMLGEN(EMPID)
---------------------------------------------------------
<?xml version="1.0"?>
<EMPID>10</EMPID>
 
<?xml version="1.0"?>
<EMPID>20</EMPID>
 
<?xml version="1.0"?>
<EMPID>30</EMPID>
 
<?xml version="1.0"?>
<EMPID>40</EMPID>
 
SYS_XMLGEN(EMPID)
 
<?xml version="1.0"?>
<EMPID>50</EMPID>
 
 
SQL> select SYS_XMLAGG(SYS_XMLGEN(empid)) FROM empleados;
<?xml version="1.0"?>
<ROWSET>
<EMPID>10</EMPID>
<EMPID>20</EMPID>
<EMPID>30</EM
                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97: