View Full Version : Access to XML data with OO4O using Oracle 9i Release 2
powerrng
06-07-2004, 09:10 AM
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?
MyLounge.com Site Map
Forum:
Cars,
Cell Phone,
Database,
Games,
Home Improvement,
IT,
Music,
School,
Sports,
Web Design,
Web Server,
Weight Loss
The MyLounge.com forum is intended for informational use only and should not
be relied upon and is not a substitute for any advice. The information contained
on MyLounge.com are opinions and suggestions of members and is not a representation
of the opinions of MyLounge.com. MyLounge.com does not warrant or vouch for
the accuracy, completeness or usefulness of any postings or the qualifications
of any person responding. Please consult a expert or seek the services of an
attorney in your area for more accuracy on your specific situation. Please note
that our forums also serve as mirrors to Usenet newsgroups. Many posts you see
on our forums are made by newsgroup users who may not be members of MyLounge.com
Term of Service
vBulletin v3.0.7, Copyright ©2000-2009, Jelsoft Enterprises Ltd.