2 Replies Latest reply on Jan 31, 2017 3:49 PM by BPeaslandDBA

    SQL Developer Formatter Request

    Yan 1701

      InTOAD you are able to format nicely named parameters in a function or procedure call within a block, so when formated is would look something like this....

       

      XXCUST_PKG.create_log_message (
                                    p_debug_level     => lv_debug_level
                                  , p_procedure_name  => lv_procedure_name
                                  , p_location_number => 10
                                  , p_message_string  => NULL
                                   );
      

       

      SQL Developer seems not format it correctly and I've tried a few options. It seems want to put the whole call on one line...

       

      XXCUST_PKG.create_log_message ( p_debug_level => lv_debug_level , p_procedure_name => lv_procedure_name , p_location_number => 10 , p_message_string => NULL );
      

       

      Any ideas on how to get it to format as I would like?

       

      I'm using version 3.2.20.10

       

      Thanks.