logger.status

[martindsouza]

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

[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.

[martindsouza]

This issue was moved to OraOpenSource#42