Re: Sharing Connection in Pro*C and OCI

Hi Kenneth,

I've tried this and could not get it to work on HP-UX in C++. The only difference is that I declared "Lda_Def lda;" to be local within a function.

Which platforms and languages have you tried this on?

Thanks,
Andrew Scott

Kenneth C Stahl wrote:
>
> Actually, there is nothing to it.
>
> 1. Define an OCI LDA globally:
> Lda_Def lda;
> 2. Make your connection to Oracle with Pro-C
> EXEC SQL CONNECT :uid IDENTIFIED BY :pwd;
> 3. Make the following call:
> sqllda(&lda)
>
> Then just pass the lda to your API.
>
> Ken
>
> interld808_at_aol.com wrote:
>
> > Does anyone have experience sharing a connection created in a program
> > that uses Pro*C with an API that uses OCI?
> >
> > I have a client that needs to maintain transactional integrity across
> > these two areas. The manual says you can do it. I am looking for real
> > world experiences, maybe some sample code.
> >
> > -- Ron Olcott, ASC Corporation.
> >
> > Sent via Deja.com http://www.deja.com/
> > Share what you know. Learn what you don't.
Received on Wed Jun 30 1999 - 20:54:31 CDT