Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Access to XML data with OO4O using Oracle 9i Release 2

Access to XML data with OO4O using Oracle 9i Release 2

From: powerrng <wohlstandswampe_at_lycos.de>
Date: 7 Jun 2004 10:10:05 -0700
Message-ID: <e26465b6.0406070910.46f85ff4@posting.google.com>


I have some problems to retrieve and manipulate xml data with OO4O(Oracle Objects for OLE).I create a vb application which send a SQL statement to the database. I use following code:

Dim mySession As OraSession
Dim myDatabase As OraDatabase
Dim myDynaset As OraDynaset

Set mySession = New OraSessionClass
Set myDatabase = MySession.OpenDatabase("XMLDEMO_HEIPC80442", "scott/tiger", 0&)

sql = "select extract(e.dfile,'//MachineType[@text=""SM_52""]/CurveType[@text=""presetting""]') from xmltest e"

Set myDynaset = myDatabase.CreateDynaset(sql, 0&) ...

In the last call, CreateDynaset(), the application breaks down with Error 04976 -> Creating OraObject instance in client-side object cache has failed. What can I do? Did I
forget some paramaters which I have to be set? Received on Mon Jun 07 2004 - 12:10:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US