• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 325
  • Last Modified:

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>' ;
      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
1 Solution
In the new package you can call the procedure and to change the placeholder.
The problem I see is the placeholder visible in the new package.
So the best way will be to define a variable for the placeholder in the new package and to run a procedure in the old package that will deliver the value.

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now