SQLEnvGet and SCLSrvCtxGet

From: Ellece <ellece_at_gradkell.com>
Date: Tue, 23 Jan 2001 09:01:51 -0600
Message-Id: <10750.127274@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0142_01C0851B.1FED4AF0 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

We are trying to write some generic OCI that we can call from a user exit. In Forms 5.0, we use ORA FFI to call a library that contains OCI code using

the SAME database connection that the Form is using. In Forms 6.0, this is

not a supported feature. (We would love to know WHY it is no longer

supported!) Oracle documentation states that a User Exit, rather than

OraFFI, must be used (to use the Forms' database connection).

In order to use OCI from a user exit in Forms 6.0, we are calling two

functions:

SQLEnvGet and SQLSrvCtxGet.

It fails on getting the context handle -- returns a -1 or -2. Sometimes it

returns a success but still returns a NULL handle.

Any suggestions?

------=_NextPart_000_0142_01C0851B.1FED4AF0 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR></HEAD>
<BODY>
<DIV>We are=20
trying to write some generic OCI that we can call from a user = exit.</DIV>
<DIV>
In Forms 5.0, we use ORA FFI to call a =
library that=20
contains OCI code = using
the SAME database connection that the =
Form is using.=20
In Forms 6.0, this is
not a supported feature. (We would love =
to know=20
WHY it is no = longer
supported!) Oracle documentation states =
that a User=20
Exit, rather than
OraFFI, must be used (to use the Forms' =
database=20
connection).
In order to use OCI from a user exit in =
Forms 6.0, we=20
are calling two
functions:
SQLEnvGet and SQLSrvCtxGet.
It fails on getting the context handle -- =
returns a=20
-1 or -2. Sometimes it
returns a success but still returns a =
NULL=20
handle.
Any suggestions?
 
 
 
 </DIV></BODY></HTML> Received on Tue Jan 23 2001 - 09:01:51 CST