Re: Database callbacks.

Go to http://govt.us.oracle.com/ and have a look at PLEX.

I implemented something like this for an extension to D&B Financials to an Oracle based manufacturing package. On the D&B side I had to use open server ... for the Oracle side I needed nothing other than the base system and used the DBMS_ALERTS and DBMS_PIPES packages (oh yeah and DBMS_JOBS for some scheduling and clean up).

UTL_FILE is OK ... we've used it for a pseudo EDI interface that allows our Oracle WebServer to pass a file through a firewall ... through SQL*Net ... through the DB to the filesystem and then some standard scripts for loading. We did this mostly to use the existing loading scripts.

Thor HW

Citton Laurent <citton_at_shom.fr> wrote in article <5hvho1$5fn$1_at_oceanie.shom.fr>...
> In article <333D34A9.56D5_at_concentric.net>, rawoods_at_concentric.net says...
> >
> >Dan Shechter wrote:
> >>
> >> Back at where I work, we have a very strong need for callbacks
 (notices
> >> sent to out applications upon insertaion to tables from the server).
> >>
> >> Those applications are running om remote systems from the oracle
 server,
> >> which implies that some sort of network connection is required.
> >>
> >> What we've come up so far, was to use a trigger upon insertation on
 the
> >> required tables, which will run a stored procedure, that will use the
> >> PL/SQL UTL_FILE package which allows to write into operating system
> >> files (or named pipes for that matter).
> >>
> >> Meanwhile, we have a small daemon, trying to read from those files.
> >>
> >> When the daemon succeeds in reading, it parses the data read, and
> >> through TCP/IP inform the interested applications.
> >>
> >> Although this should work (OK, we haven't really tried it yet...),
> >> I was wandering if anybody had ever met the same problem with a better
> >> solution.
> >>
> >> Despratly awaiting.
> >> Dan.
> >Dan,
> >
> >You can use the DBMS ALERTS package to send e-mail too, although this
> >asynchronous approach may not be what you need.
> >--
> >Rich Woods
> >Technical Field Support Specialist, Oracle Corporation, USA
> >The above statements and opinions are my own and do not
> >necessarily represent those of Oracle Corporation.
>
> You can use DBMS_PIPE package too to synchronously send a message to a
> deamon.
>
>
> --
> Laurent CITTON (citton_at_shom.fr)
> E.P.S.H.O.M (www.shom.fr)
> 13 rue du Chatellier
> BP 426
> 29275 BREST cedex
> FRANCE
>
>
Received on Tue Apr 08 1997 - 00:00:00 CDT