CODEWITHSUNDEEP
plsqltriggersoracle10g
RobLaw84
RobLaw84

Reputation: 175

Commit update before raising error in trigger

I am writing an after update trigger to log the username and time of updates to a specific column. I need the update to commit and then a message displayed to the user to advise them to do something else. I am unable to use dbms_output.put_line as the application hides these messages from the user (changing the aplication is impossible as its a third party application and licensing issues prevent any changes). I have tried using raise_application_error which displays the message but because it is raising an error it prevents the update from commiting.

Does anyone know of a way around this?

Upvotes: 1

Views: 388

Answers (2)

schurik
schurik

Reputation: 7928

there is a nasty workaround, if there is no other alternative. In the Trigger you can first submit a job (dbms_job.submit) and make an update within the job. And then raise an error.

Upvotes: 0

Tony Andrews
Tony Andrews

Reputation: 132580

There is no way to present a message to the user in real time without changing the application. If you hold all the users' email addresses I suppose the trigger could send them an email telling them what they need to do?

Upvotes: 1

Related Questions