.dsy:it. - Inserire XML nell'ORACLE XML REPOSITORY

.dsy:it.
//www.dsy.it

Inserire XML nell'ORACLE XML REPOSITORY

Posted by Mark116 on 23-01-2016 09:28

Il Prof Mesiti mi ha inviato il codice necessario per inserire un pdf nell'ORACLE XML REPOSITORY:

DECLARE
res BOOLEAN;
empsxmlstring VARCHAR2(300):=
'<?xml version="1.0"?>
<emps>
<emp empno="1" deptno="10" ename="John" salary="21000"/>
<emp empno="2" deptno="10" ename="Jack" salary="310000"/>
<emp empno="3" deptno="20" ename="Jill" salary="100001"/>
</emps>';
deptsxmlstring VARCHAR2(300):=
'<?xml version="1.0"?>
<depts>
<dept deptno="10" dname="Administration"/>
<dept deptno="20" dname="Marketing"/>
<dept deptno="30" dname="Purchasing"/>
</depts>';
BEGIN
res := DBMS_XDB.createResource('/public/emps.xml', empsxmlstring);
res := DBMS_XDB.createResource('/public/depts.xml', deptsxmlstring);
END;