Re: calling plsql with invoker rights from trigger

From: Mark Bole <makbo_at_pacbell.net>
Date: Mon, 23 Feb 2004 15:36:26 GMT
Message-ID: <_5p_b.1621$TT7.1549@newssvr27.news.prodigy.com>

Daniel Morgan wrote:

> Billy Verreynne wrote:
>

>> Mark Bole <makbo_at_pacbell.net> wrote in
>>
>>
>>> Are you saying that this would be much better as a DBMS_ALERT, rather 
>>> than a trigger?  The LDAP update should be concurrent with the table 
>>> update, although if it fails it isn't fatal.
>>
>>

[...]

>>
>> I would say the latter. In which case a trigger is most certainly not
>> the right tool for updating the LDAP server.
>>
>> -- 
>> Billy

>
>
> Consider putting the code dealing with issues that don't relate
> specifically to the transaction into a stored procedure set up
> with PRAGMA AUTONOMOUS_TRANSACTION. That way if it fails no harm
> is done.
>

Thanks for the good suggestions/thoughts that I will be following up on locally.

--Mark Bole Received on Mon Feb 23 2004 - 09:36:26 CST