2 Replies Latest reply: Jul 1, 2011 9:13 AM by 730428 RSS

    How to display CLOB in sqlplus

    Yoav
      Hi,

      Additional_info column in DBA_SCHEDULER_JOB_LOG is CLOB type.
      SQL> SET LONG 32000
      SQL> select status , additional_info 
        2  FROM DBA_SCHEDULER_JOB_LOG
        3  where log_id=429667;
      
      STATUS                         ADDITIONAL_INFO
      ------------------------------ --------------------------------------------------------------------------------
      FAILED
      Whey i am not getting any value in ADDITIONAL_INFO column ?

      Thanks
        • 1. Re: How to display CLOB in sqlplus
          Hoek
          Because it's not applicable? (the column is not defined as mandatory/NOT NULL)

          "ADDITIONAL_INFO CLOB Additional information on the entry, *if applicable*"
          http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_2047.htm#i1587038
          • 2. Re: How to display CLOB in sqlplus
            730428
            Yoav wrote:
            Whey i am not getting any value in ADDITIONAL_INFO column ?
            Maybe because for that job log the additional_info column is null:
            SQL> set null @
            SQL> select additional_info from DBA_SCHEDULER_JOB_LOG where rownum<5;
            
            ADDITIONAL_INFO
            --------------------------------------------------------------------------
            @
            @
            @
            @
            Max