Link to home
Start Free TrialLog in
Avatar of thota198
thota198

asked on

regarding placeholders

i have added placeholder and replaced its values in a package
but im sending email from a different package but same database
here is the placeholder name

 io_email_replace_vals (179).fieldname := '|NON_PRODUCTION_BANNER|';

here is the placeholder value:
select name into v_db_name from v$database;
      IF v_db_name <> 'DMPROD' THEN
      io_email_replace_vals (179).fieldvalue :=
      '============= THE FOLLOWING SECTION WILL NOT APPEAR ON PRODUCTION ============= ' || CHR(10) ||
      'DB = ' ||v_db_name  || CHR(10) ||
      'TO = <to>'  || CHR(10) ||
      'CC = <cc>'  || CHR(10) ||
      'BCC= <bcc>' ;
     
      ELSE
      io_email_replace_vals (179).fieldvalue := '';
      END IF;

My question is should i enter these two again in the new package where im sending the email or just call the procedure
ASKER CERTIFIED SOLUTION
Avatar of schwertner
schwertner
Flag of Antarctica image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial