chris webster wrote:We'd probably need to see some code as it's hard to guess otherwise e.g. have you got your "WHEN" clauses in the right order, are you sure the exception is being raised, are you sure it's not being caught in the calling proc?
I found out what was causing the problem. I was trying to set the value of error_code_in to -390, but this error code was not initialized with the pragma exception_init() function.
q$error_manager.raise_error
(
error_code_in => -390,
text_in => 'Cannot lock revision.'
);