> If it is not possible to return error from
> trigger procedure, what could be the possible
> way to solve the above problem.
What you want is 'raise exception', which allows you to return an
error message explaining things.
Use something like "RAISE EXCEPTION ''You are not authorized to
update this information'';"
--
Mike Nolan