Message-Id: <10750.127274@fatcity.com> From: "Ellece" Date: Tue, 23 Jan 2001 09:01:51 -0600 Subject: SQLEnvGet and SCLSrvCtxGet 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
We are=20 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=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?