Skip to content

Function to return the Trigger Action #191

@martindsouza

Description

@martindsouza

In triggers the following conditional predicates are available: insert, updating, deleting.

Logging the type of trigger event can require a bunch of repetitive code. Have a function that looks like (pseudo code):

l_return := case
  when inserting then 'inserting'
  when updating then 'updating'
  when deleting then 'deleting'
  else null; -- This will occur when not in a "each row" trigger

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions