Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE PROCEDURE my_proc(
  i_value1                 IN NUMBER,
  i_use_concurrent_logging IN BOOLEAN DEFAULT FALSE
)
IS
  PROCEDURE log(value IN VARCHAR2)
  IS
  BEGIN
    IF i_use_concurrent_logging THEN
      -- put your concurrent logging code here.
      NULL;
    ELSE
      DBMS_OUTPUT.PUT_LINE(value);
    END IF;
  END;
BEGIN
  -- Do stuff.
  
  log('Stuff done');

  -- Do other stuff

  log('Other Stuff done');
END;
/
SELECT * FROM USER_ERRORS;
BEGIN
  DBMS_OUTPUT.PUT_LINE('Initialise buffer');
  my_proc(42);
END;
/
1 rows affected

dbms_output:
Initialise buffer
Stuff done
Other Stuff done

BEGIN
  DBMS_OUTPUT.PUT_LINE('Initialise buffer');
  my_proc(42, TRUE);
END;
/
1 rows affected

dbms_output:
Initialise buffer

CREATE OR REPLACE PROCEDURE my_proc(
  i_value1                 IN NUMBER
)
IS
  v_use_concurrent_logging BOOLEAN := FALSE;
  
  PROCEDURE log(value IN VARCHAR2)
  IS
  BEGIN
    IF v_use_concurrent_logging THEN
      -- put your concurrent logging code here.
      NULL;
    ELSE
      DBMS_OUTPUT.PUT_LINE(value);
    END IF;
  END;

BEGIN
  DECLARE
    v_exists INT;
  BEGIN
    SELECT 1
    INTO   v_exists
    FROM   sys.fnd_concurrent_requests
    WHERE  oracle_session_id = userenv('SESSIONID');
    
    v_use_concurrent_logging := TRUE;
  EXCEPTION
    WHEN NO_DATA_FOUND THEN
      v_use_concurrent_logging := FALSE;
  END;

  -- Do stuff.
  
  log('Stuff done');

  -- Do other stuff

  log('Other Stuff done');
END;
/
ORA-24344: success with compilation error

SELECT * FROM USER_ERRORS;


NAME
TYPE
SEQUENCE
LINE
POSITION
TEXT
ATTRIBUTE
MESSAGE_NUMBER


MY_PROC
PROCEDURE
1
24
16
PL/SQL: ORA-00942: table or view does not exist
ERROR
0

MY_PROC
PROCEDURE
2
22
5
PL/SQL: SQL Statement ignored
ERROR
0

NAME	TYPE	SEQUENCE	LINE	POSITION	TEXT	ATTRIBUTE	MESSAGE_NUMBER
MY_PROC	PROCEDURE	1	24	16	PL/SQL: ORA-00942: table or view does not exist	ERROR	0
MY_PROC	PROCEDURE	2	22	5	PL/SQL: SQL Statement ignored	ERROR	0