error with proc parameters

Posted on 2011-05-03
Last Modified: 2013-12-07
PROCEDURE get_email_contents (
      o_rc                  OUT      NUMBER,
      o_reason              OUT      VARCHAR2,
      i_deal_id             IN       cq_deal.opty_number%TYPE,
      i_quote_object_id     IN       cq_quote.object_id%TYPE,
      i_email_cd            IN       cq_message_type.MESSAGE_TYPE%TYPE,
      i_user_id             IN       VARCHAR2,
      i_approver_seq        IN       cq_pdr_appr_route_vw.queue_seq%TYPE DEFAULT 1,
      i_locale              IN       VARCHAR2 DEFAULT 'en_US',
      ---to handle localisation
      o_email_from          OUT      cq_message_type.message_from%TYPE,
      o_email_to            OUT      cq_message_type.message_to%TYPE,
      o_email_cc            OUT      cq_message_type.message_cc%TYPE,
      o_email_subject       OUT      VARCHAR2,
      o_email_reply_to      OUT      cq_message_type.message_reply_to%TYPE,
      o_email_text          OUT      cq_notification.message_body%TYPE,
      i_source_profile_id   IN       NUMBER DEFAULT NULL,
      o_file_name           OUT      VARCHAR2,
      o_file_data           OUT      BLOB,
      i_order_number        IN       dm_order_header.web_order_id%TYPE
   --added for Q2O notifications
      o_mail_to             OUT     cq_notification.message_to%TYPE,
      o_mail_cc             OUT    cq_notification.message_cc%TYPE,
      o_email_bcc           OUT     cq_notification.message_bcc%TYPE
      --added for printing a banner in email body incase of nonproduction---
after adding the above banner i got the error

Syntax check (3023: 7): Found:  'o_mail_to' Expecting: )  ,   -or-   :=  DEFAULT
Question by:thota198
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    What banner did you add?  I don't see it.

    Is this part of a package?  If so, I think the problem is in either the package definition of the package body.  The section you didn't paste the the above code from.

    My guess is you are missing a ',' (comma) before o_mail_to.
    LVL 3

    Accepted Solution

    It is really missing a comma after "  i_order_number        IN       dm_order_header.web_order_id%TYPE".

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Introduction A previously published article on Experts Exchange ("Joins in Oracle", makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
    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.

    760 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

    12 Experts available now in Live!

    Get 1:1 Help Now