Re: Waking up Pro*c prog.
From: Nigel Noble <nigel_at_churchill.co.uk>
Date: Thu, 28 Jul 1994 08:42:43 GMT
Message-ID: <Ctn6v9.GJ2_at_churchill.co.uk>
Date: Thu, 28 Jul 1994 08:42:43 GMT
Message-ID: <Ctn6v9.GJ2_at_churchill.co.uk>
Yes,
You can create a database trigger which makes a call to the oracle
dbms_pipes packages. Your pro*c program can wait at the pipe for
information. This information could say 'start processing'.
Regards
Nigel Noble
Juergen Barth (barth_at_newsserver) wrote:
: Is there any chance to "wake up" a pro*c program if an action took
: place (i.e. Insert in an table) in the database.
: In database triggers you are only allowed to use SQL and PL/SQL
: commands.
: I work with Oracle 7.0.15 and SUN/OS 4.1.3
: Thanx Juergen
-- _____________ Nigel Noble churchill Tel: +44 81 313 5677 Database Administrator ============= Fax: +44 81 313 5699 Churchill Technology Ltd 15-17 London Rd, Bromley BR1 1DE, UK. Email: nigel_at_churchill.co.ukReceived on Thu Jul 28 1994 - 10:42:43 CEST