regarding placeholders

Posted on 2011-05-09
Last Modified: 2012-05-11
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
Question by:thota198
    1 Comment
    LVL 47

    Accepted 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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
    Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
    Via a live example, show how to take different types of Oracle backups using RMAN.
    This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now