Re: Q: Asynchronous processing

From: huh <huhhy_at_rocketmail.com>
Date: Mon, 9 Aug 1999 17:35:29 +0200
Message-ID: <7omshk$2483$1@ns.felk.cvut.cz>

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 Mon Aug 09 1999 - 10:35:29 CDT