Re: GPF with OracleObjects for OLE - HELP!

In article <431p94$iue_at_sparcserver.lrz-muenchen.de>, u7l11ai_at_sun1.lrz-muenchen.de (Mark Sandor) writes:

> Hi all,
 

> i've got a prob concerning a VB 3.0 application using Oracle
> Objects for OLE V. 1.0.42.0.0 . When I deal with little data, e.g.
> querying a table "SELECT name FROM table" everything works fine.
> But if the query returns more columns ("SELECT * FROM table") i
> occasionally get GPFs (in Module VBOA300.DLL).
 

> This really seems to be an OO-VB prob, because if I use a statment
> like "SET fld=nothing" after I used the fld-variable to access the
> return-set, the GPFs are less often.
 

> I think, OO V. 1.0.42 is the latest version available from Oracle.
> It is very important for me, that this application will run, so
> are there any possible solutions? Any new versions? updates? ..?
 

> If I cant manage this problem, i think i have to switch to ODBC. I
> would regret this step, because (except for the f****** GPFs) OO
> are OK.
 

> Any help/suggestions welcome.
 

> cu all Mark

Hi Mark,

you don't mention how many columns you are returning, but I trip over this bug (GPF in VBOA300.DLL at 0001:0D03) whenever i have more than ~115 OLE objects. With my app this works out to a bit more than 100 total columns. It's definitely an MS bug, but I have been unable to even get a status out of MS other than that it's a recognized bug. There's some marginally related info in the bug-VBKB articles Q113438 and Q114000, but nobody seems to have found the number-of-objects bug before me, or at least neither MS nor Oracle admitted to ever hearing about it....

I have found OO4O to be slightly faster than ODBC, particularly for updates, and have been able to keep the object count down by loading some small tables into memory arrays. This may turn out to be unacceptable in which case I will fall back on ODBC until VBOA300.DLL gets fixed. I won't be holding my breath though...

good luck, david Received on Tue Sep 12 1995 - 00:00:00 CEST