upload xml file into xmltype col via a form
515325Jul 6 2006 — edited Jul 6 2006hi to all,
i'm trying to upload an xml to an xmltype column of a table:
Is there a pl/sql xmldb instructions for converting the existing temporary blob into an xmltype and storing it directly into a table?
in a event on submit after computations and validations i have written the following code:
XMLTABLE1 is the table where i plan to store the xml as xmltype.
IF (:P14_FILE_NAME is not null) then
INSERT into XMLTABLE1
(ID, TITLE, XMLCONT)
SELECT ID, :P14_FILE_NAME, XMLTYPE(BLOB_CONTENT)
FROM HTMLDB_APPLICATION_FILES WHERE NAME=:P14_FILE_NAME;
DELETE FROM HTMLDB_APPLICATION_FILES WHERE NAME=:P14_FILE_NAME;
END IF;
NOTE: I DON'T WANT TO UPLOAD XML USING THE APEX GUI. tHE UPLOAD SHOULD BE EXECUTED LIKE AN UPLOAD OF BLOB FILE, BUT USING AN XMLTYPE FIELD AS DESTINATION FOR STORING THE XML.
thanx
Message was edited by:
Marcello Nocito