Re: Q: Asynchronous processing

I'm sort of learning this myself at the moment, but there are ways to make a SP "listen"
over a pipe. I don't know if that helps you exactly. It is also possible with Pro*C,
and I imagine Pro*C++ (which I think exists although I haven't used), which can listen
over an Oracle Pipe as well. See technical support bulliten 105688.158. As far as your production server not having dll's. I don't quite follow. You can
make your own with the ld command, no?

• Dc.

huh wrote:

> Doug,
>
> I found that I can't use the intented approache.
> ORACLE job scheduler can run PL/SQL SP only (correct me please if I'm
> wrong).
> I was also told that to invoke an executable from trigger is not very
> straightforward
> solution.
>
> I need do my work in C++ and there are two problems -
>
> Callback SPs are supported only via OCI (I'd like to use ODBC :-( however
> OCI, provided that this
> code would be fully on the server side, wouldn't be a problem )
> and are supported under platforms which are familiar with DLL concept
> - our target (production) platform for server has neither DLLs nor ODBC
> -( YUCK!
>
> What about your solution, how will you make the "listener"?
> How will you force your SP to be listening?
>
> My intention was to bind my code as close to RDBMS as possible, but
> unfortunatelly I have to give it up.
>
> There will be an external process (service/deamon) which will "listen" on
> RDBMS event and do
> his job through his own connection.... In such case it doesn't matter
> whether I do simple insert/update
> or write to an ORACLE pipe.
>
> If you find smarter solution please let me know.
>
> --
> Thank you for keeping >anti-spam< habit:
> not including my address in your reply.
Received on Tue Aug 10 1999 - 09:54:04 CDT