Why doesn't raise_application_error work correctly?

Question

Oracle

Hello, in the trigger I use a line raise_application_error(-20500,'Keep out!');to break the connection ... but after the trigger works, I get

Ora-00604: error occureed at recursive SQL Level 1
Ora-20500: Keep out!
Ora-06512: at line 63

What could be wrong?

Answer 1

The mistake is in the question. By itself, raise_application_error does not know how to break connections, this is done on the client side. Those. you need to execute Connection::close() or something like that when you get sqlerror -20500, depends on.

Answer 2

Is there a trigger text?

Answer 3

What is your trigger? What makes you think that raise_application_error should terminate the connection?