Page 1 of 1

Error retrieving data from a table with an XMLtype

Posted: Tue 22 Jun 2010 06:03
by stratdaz
I'm trying to retrieve data from an Oracle 9i table with an XMLtype column and I get this error ...

=========================
Exception Information
=========================
Message: Unable to load DLL 'c:\Oracle\11.2.0\client_32\oraclient11.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)
Source: OciCall.dll

I'm running Windows Server 2008 (64 bit) and I have oracle 11g 32 and 64 bit clients installed but I can't find a file named "oraclient11.dll" anywhere.

Posted: Tue 22 Jun 2010 08:11
by stratdaz
I believe the dll was missing since I had only oracle InstantClient installed. I have since installed the administrator client and now have the missing oraclient11.dll.

Unfortunately, I still have the following error ...

Message: Unable to load DLL 'C:\Oracle\11.2.0\client_32\oraclient11.dll': The specified procedure could not be found. (Exception from HRESULT: 0x8007007F)

Not sure if this is any help but I get this message from Process Monitor when I run the query ...

Class: File System
Operation: CreateFileMapping
Result: FILE LOCKED WITH ONLY READERS
Path: C:\Oracle\11.2.0\client_32\oraclient11.dll

Posted: Tue 22 Jun 2010 12:02
by Viktor
Unfortunately, we cannot reproduce this problem.
Tell the full versions of Oracle client (four numbers), OraDeveloper Studio or OraDeveloper Tools you are using.
If possible, send us oci.dll and oraclient11.dll.

Posted: Wed 23 Jun 2010 00:42
by stratdaz
Oracle client version is 11.2.0.1.0

Tried this in VS2008 using OraDeveloper version 2.55.168 and VS2010 with OraDeveloper version 2.60.174

I have attached the full Error Report and dll files to a support email.

Posted: Wed 23 Jun 2010 06:34
by .jp
Thanks, we have received the error report generated by our tool.
Now we are investigating the problem.