Oracle stored proc fails without raising exception

[DaPi]

My application executes the stored proc and retrieves the records affected.

Are you sure that the same session is doing both?