Re: Is this possible?

[Alan Dalton <adalton@SIERRASYS.COM>]

I did something similar using an IBM program called MQSeries.  The MQ
queue triggered the SQR update program.  This works well if you have
data (transactions or files) coming from another source.  It can be done
batch or real-time.  MQSeries handles the audit trail and error/recovery
processing for the transmission (but not for the update process).

HTH, Alan

> ----------
> From:         Julie Cochrane[SMTP:Julia_Cochrane@IINT.COM]
> Sent:         Friday, May 29, 1998 12:17 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Is this possible?
> I've been handed a project to write an interface where my boss's
> conception
> of how
> this interface would work is that a trigger on the interface table
> will
> initiate an SQR program
> that will control putting the information into the base tables.  Since
> it
> will happen realtime,
> she doesn't want more than one record being handled at a time.
>
> Is it even possible to have a PL/SQL trigger initiate an SQR program?
>
> What would be gained by doing it this way as opposed to having the
> trigger
> call a PL/SQL
> procedure to handle the necessary transactions?
>
> I also need to write audit and error reports to go with this thing,
> but
> those are pretty plain
> vanilla.
>
> Any help would be much appreciated.
>
> Thanks,
>         Julie
>