Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: External Procedures: Embedded SQL and OCI callbacks both possible?
Hi there.
Have you checked the documentation, eg
http://download-west.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89861/pc
_07pls.htm#8055.
It mentions using
EXEC SQL REGISTER CONNECT USING :epctx RETURNING :host_context;
thus connecting Pro*C and getting OCI environment handles in one go.
HTH. Cheers,
Finn
"Stewart Houck" <shouck_at_pnm.com> wrote in message
news:wTYZ8.563$5r7.93319216_at_newssvr15.news.prodigy.com...
> Oracle 8i Enterprise Edition 8.1.7.3
>
> I have the need in an external procedure (Pro*C) to both call a procedure
> containing embedded SQL and to also use an OCI callback. I can
successfully
> do one or the other, but not both. It seems that the problem has to do
with
> the contexts they both need (though I'm not sure). The following
statements
> are at the beginning of the routine to set the contexts:
>
> status = OCIExtProcGetEnv(ctx, &envh, &svch, &errh);
> EXEC SQL register CONNECT USING :ctx;
>
> With the above statements, I receive an ORA-1012 (not logged on) error
when
> the SQL is executed. If I reverse the order, I get an ORA-03114 (not
> connected to oracle) and then ORA-03113 (end-of-file on communication
> channel), and I seem to lose the connection to the extproc.
>
> Is it possible to use both Embedded SQL and OCI callbacks in one call to
an
> external procedure? If so, how is it done.
>
> Thanks
>
>
Received on Tue Jul 23 2002 - 03:50:28 CDT