Re: PL/SQL question

--- Mike Nolan <nolan@gw.tssi.com> wrote:
> >     In fact the problem seems to come from the
> "INSERT INTO". I delete
> > everything from the function and only keep the
> "INSERT INTO" and get the
> > same problem.
>
> Given that this is supposed to be a trigger
> function, what's
> your 'create trigger' statement look like?
>
> Part of the problem may be how your 'return null' is
> being handled,

AFAIK, returning null from a trigger function causes
the whole operation (insert, update or delete) to be
aborted, so the transaction is rolled back, including
the insert inside the function.  You want to return
NEW instead.

> and that can be related to when the trigger fires.
> --
> Mike Nolan
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 8: explain analyze is your friend





__________________________________
Do you Yahoo!?
Yahoo! Photos: High-quality 4x6 digital prints for 25�
http://photos.yahoo.com/ph/print_splash