declare first_row pls_integer := dbms_application_info.set_session_longops_nohint; second_row pls_integer := dbms_application_info.set_session_longops_nohint; slno1 pls_integer; slno2 pls_integer; begin dbms_application_info.set_session_longops(rindex => first_row ,slno => slno1 ,op_name => '1_op' ,sofar => 1 ,totalwork => 2 ,units => 'step' ); dbms_application_info.set_session_longops(rindex => second_row ,slno => slno2 ,op_name => '2_op' ,sofar => 1 ,totalwork => 1 ,units => 'step' ); dbms_application_info.set_session_longops(rindex => first_row ,slno => slno1 ,op_name => '1_op' ,sofar => 2 ,totalwork => 2 ,units => 'step' ); end; / select MESSAGE from v$session_longops where (sid,serial#) = (select sid,serial# from v$session where audsid = USERENV('SESSIONID'));Тема на SQL.RU: set_session_longops Можно ли вернуться к предидущей строке?
Coalesce SQ bug
2 недели назад
Комментариев нет:
Отправить комментарий