Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 308
  • Last Modified:

Native Handle problems with Oracle 8

I am having problems obtaining the native database handle (LDA) from an Oracle 8 database. The code I am using works with Oracle 7.3 but not for 8? Any ideas or a solution would be appreciated.

function GetNativeDBHandle(var NativeHandlePtr: Pointer): Word;
var LDAHandleBuf : array [0..68] of byte;
begin
  Result := 0;
  // Get the native handle to the database...
  DbiGetProp(hDBIObj(database.Handle), dbNATIVEHNDL,  @LDAHandleBuf,
    sizeof(LDAHandleBuf), Result);
  NativeHandlePtr := @LDAHandleBuf;
end;
0
rikjc
Asked:
rikjc
  • 2
1 Solution
 
SChertkovCommented:
What version of Oracle Client you installed,
and what SQL Link drivers (for 8.0 or 7.3) you used ?
0
 
fvaCommented:
The Oracle API layer under BDE has changed from 7.3 to 8. BDE is using LDA and normal 8 OCI operations are based on service context. Since I presume you are using OCI calls with that LDA you got on 7.3, take a look at OCI 8 doc, especially at "OCILdaToSvcCtx()".

F.
0
 
rikjcAuthor Commented:

I figured out that the LDA was no longer supported under 8 OCI. However thanks for the feedback.
0
 
fvaCommented:
Well, since then 9i is out and already wearing out :)
However, thank you for the points.

F.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now