Is this possible?

[Julie Cochrane <Julia_Cochrane@IINT.COM>]

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