Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Raise statement in a package.

TinaJun 9 2011 — edited Jun 10 2011
I am just curious about the raise statement used in plsql.

exception
when others then
dbms_application_info.set_module('', '');
dbms_application_info.set_client_info('');
x_err_code := sqlcode;
x_err_message := sqlerrm;
log_message(p_message => x_err_message,
p_proc_name => lc_proc_name,
p_event_status => constants_pkg.event_error);
log_message('excpt5', lc_proc_name);
raise; ------------------------------------------------------------------------------------------------------------what does it do?it is not associated with any exception.
end apply_payment_by_vtxn;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 8 2011
Added on Jun 9 2011
8 comments
227 views