8.1.7 XDK PL/SQL parser
Date: Tue, 18 Feb 2003 16:17:58 +0100
Message-ID: <b2timk$959$1_at_atlantis.news.tpi.pl>
Hello,
I use Oracle 8.1.7 on Win2k Server SP2. I am working on procedure which task will be to load data from the XML file to the database. I use XDK and PL/SQL parser included in the 8.1.7 installation. It seems to work fine until I try to set values to new nodes which I put into the DOM tree ( I want to add <id> and <status> elements filled with the inserted record id and returned operation status to every <record> element):
insertedId NUMBER;
(...)
nId := XMLDOM.MakeNode(XMLDOM.CreateElement(doc,'id'));
nId := XMLDOM.AppendChild(nRecord, nId);
XMLDOM.SetNodeValue(nId, insertedId);
The <id> element is properly inserted in the DOM tree. But the 3rd line causes User-Defined Exception with SQLCODE = 1. Does anybody know a solution?
Mike Received on Tue Feb 18 2003 - 16:17:58 CET