SQL Language (MOSC)

MOSC Banner

servererror

edited Feb 18, 2010 4:32AM in SQL Language (MOSC) 2 comments
hello,

in servererror trigger we use 

FOR n IN 1..ora_server_error_depth LOOP insert into log_errors_tab values (id, sysdate , ora_login_user, ora_client_ip_address, ora_server_error(n), ora_server_error_msg(n)); END LOOP

n IN 1..ora_server_error_depth LOOP insert into log_errors_tab values (id, sysdate , ora_login_user, ora_client_ip_address, ora_server_error(n), ora_server_error_msg(n)); END LOOP log_errors_tab values (id, sysdate , ora_login_user, ora_client_ip_address, ora_server_error(n), ora_server_error_msg(n)); END LOOP

ora_client_ip_address

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center