Re: Trigger problem (confusing)

Hi,

It's a bit tricky to tell what the problem might be without knowing the structure of the underlying tables, however there are a few things you might want to look at.

1. Re-create the trigger without the WHEN OTHERS exception. It should still fail, but you should receive the underlying ORA- error message which may give us a better clue as to what is happening;
2. Define your first select as a cursor (is it possible you are returning more than 1 row?). This will be more efficent and give you more control over the data returned.
3. I notice in the update statement you are generally inserting :new.field_name into field_name. :NEW.ZNES_PREDOB into PGR_ZNE_UPO seems to go against this - is this OK?

Hope this helps,

Ian Received on Wed Nov 19 1997 - 00:00:00 CST