Subject Re: stored procedure doing an update
Author Adam
--- In, "christophermarkstrauss"
<christopher@s...> wrote:
> Hi All
> can someone please help, i am writing my first update procedure and
> am having a problem with the error trapping.
> in my strored procedure (Update section), if i pass it a non existant
> record key (IP_FKey) then the SQL does not jump to the WHEN ANY
> statement but continues as if the update succeeded.

Hello Christopher,

A non existent record is not an exception unless you decide it is
within the EP_REGISTER_EVENT stored procedure and raise one.

To test how many records an update statement modified inside a stored
procedure, you can look at the ROW_COUNT variable.

Post the source of "EP_REGISTER_EVENT" if you need more information.