Re: OCI wrapper library

Thanks Stephane.

What I want to do is to write a simple transparent transaction manager, preferrably by having my program listening on a TCP socket. The client would connect to my written daemon which passes requests on to server and returns resultst to client.

The purpose? Just fun. And I'd like to advance my C programming skills.

Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, August 28, 2003 11:19 AM

> Not sure that I understand quite well what you want to do (catching
statements? Some à la Sybase 'Open Server' ?) but it is possible that what is defined in the OCI FM as 'user defined callbacks' is, partly, what you are looking for (I have never used them); I *think* I have read something once in the Oracle docs about functions allowing to write a mock Oracle server but I can't remember where. Don't think it was in the OCI manual. Concerning tcp/ip, an idea which I have toyed with (but not carried very far, like so many ideas) was to use the 'netcat' program which you should find on the web (or anything derived from it) as a frontal to tnslsnr; I have no idea though about how to plug into the dialogue between a client and a dedicated or shared server.
>
> HTH
>
> SF
>
> >----- ------- Original Message ------- -----
> >From: "Tanel Poder" <tanel.poder.003_at_mail.ee>
> >To: Multiple recipients of list ORACLE-L
> ><ORACLE-L_at_fatcity.com>
> >Sent: Wed, 27 Aug 2003 14:14:26
> >
> >I'm sending this post here, because got no response
> >in c.d.o.s.
> >
> >Does anyone have an example how to write an OCI
> >wrapper library, that I
> >could replace the Oracle OCI library with my own
> >(renaming original =
> >one).
> >Then whatever OCI call is made, it ends up to my
> >library where from I =
> >can pass
> >it on, or modify it before that?
> >
> >Also, any information on doing the same thing using
> >TCP sockets =
> >(mediating
> >between client & server sql*net connection), is
> >welcome as well.
> >
> >Any pointers are welcome, or otherwise... I'll have
> >to figure it out =
> >myself...
> >
> >Tanel.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Stephane Faroult
> INET: sfaroult_at_oriolecorp.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).