PL/SQL Formatting of AS/IS/RETURN

2 Posts
2 Users
0 Likes
159 Views
(@jasonccrane)
Member
Joined: 11 months ago
Posts: 7
Topic starter  

Is it possible to add formatting options to the AS, IS and RETURN keywords in FUNCTIONS/PROCEDURES/PACKAGES so that they can be configured either on the same line or after the definition line?

This option would allow this PL/SQL to be formatted like the following:

CREATE OR REPLACE PACKAGE BODY pkg_archive_process
AS
  gerror          NUMBER;
  gpackageversion NUMBER;

FUNCTION l_f_get_process_id (a_process_name VARCHAR2) 
  RETURN NUMBER
IS
  PRAGMA AUTONOMOUS_TRANSACTION;
  l_process_id NUMBER;
...

would become...

CREATE OR REPLACE PACKAGE BODY pkg_archive_process AS
  gerror          NUMBER;
  gpackageversion NUMBER;

FUNCTION l_f_get_process_id (a_process_name VARCHAR2) RETURN NUMBER IS
  PRAGMA AUTONOMOUS_TRANSACTION;
  l_process_id NUMBER;
...

   
Quote
Guido
(@admin)
Member Admin
Joined: 2 years ago
Posts: 172
 

Hi jasonccrane,

thanks for your post.

Technically this would be possible but I have to find a way how to add these options without confusing the users too much.

Will think about this one

Regards

Guido


   
ReplyQuote
Share: