Search notes:

Oracle: DBMS_PREPROCESSOR

alter session set plsql_ccflags='';

create or replace package tq84_pkg as -- {

    procedure p;

end tq84_pkg; -- }
/

create or replace package body tq84_pkg as -- {

    procedure p is
    begin

      $if $$tq84_flg $then
          dbms_output.put_line('$$tq84_flg is true');
      $else
          dbms_output.put_line('$$tq84_flg is not true');
      $end

    end p;

end tq84_pkg; -- }
/


create or replace procedure tq84_pkg_print_source as -- {
  source_lines dbms_preprocessor.source_lines_t;
begin

  dbms_output.new_line;

  source_lines := dbms_preprocessor.get_post_processed_source (
    object_type => 'PACKAGE BODY',
    schema_name =>  user,
    object_name => 'TQ84_PKG'
  );

  for i in 1 .. source_lines.count loop
      dbms_output.put_line(to_char(i, '99') || ': ' || replace(source_lines(i), chr(10), ''));
  end loop;

end tq84_pkg_print_source; -- }
/

exec tq84_pkg_print_source;

alter package tq84_pkg compile plsql_ccflags='tq84_flg:true';

exec tq84_pkg_print_source;

drop package   tq84_pkg;
drop procedure tq84_pkg_print_source;
Github repository Oracle-Patterns, path: /Installed/dbms/preprocessor/get_post_processed_source_1.sql

See also

Conditional compilation in PL/SQL.
Oracle DBMS PL/SQL packages

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1758207230, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/installed/packages/dbms/preprocessor/index(93): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78