logger.status

[martindsouza]

From @martindsouza on August 31, 2013 11:34

Received the following error when viewing logger status in SQL*Plus when a client identifier has been set.

SQL> exec logger.status;
BEGIN logger.status; END;

                                         *
ERROR at line 1:
ORA-01830: date format picture ends before converting entire input string
ORA-06512: at "LOGGER", line 1310
ORA-06512: at line 1

Copied from original issue: tmuth#41

[martindsouza]

In logger.status modified l_cur_expiry_date to varchar2(30) to handle it as a string as it is being converted to a string.