1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

ORA-06550 and PLS-00306

Discussion in 'SQL PL/SQL' started by manasa, Jun 10, 2013.

  1. manasa

    manasa Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    I am getting an error

    PLS-006306: wrong number or types of arguments in call to 'REQUEST_SALES_ORDER'
    ORA-06550: line 3, column 1:
    PL/SQL: Statement Ignored

    here is my procedure

    CREATE OR REPLACE PROCEDURE APPS.REQUEST_SALES_ORDER
    (p_parameter1 NUMBER,
    p_parameter2 VARCHAR2,
    p_parameter3 VARCHAR2,
    p_parameter4 VARCHAR2,
    p_parameter5 VARCHAR2,
    p_parameter6 NUMBER,
    p_parameter7 NUMBER,
    p_parameter8 DATE,
    p_parameter9 DATE,
    p_parameter10 VARCHAR2,
    p_parameter11 VARCHAR2,
    p_parameter12 VARCHAR2,
    p_parameter13 VARCHAR2,
    p_parameter14 DATE,
    p_parameter15 DATE,
    p_parameter16 DATE,
    p_parameter17 DATE,
    p_parameter18 DATE,
    p_parameter19 DATE,
    p_parameter20 VARCHAR2,
    p_parameter21 VARCHAR2,
    p_parameter22 VARCHAR2,
    p_parameter23 VARCHAR2,
    p_parameter24 VARCHAR2,
    p_parameter25 VARCHAR2,
    p_parameter26 VARCHAR2,
    p_parameter27 VARCHAR2,
    p_parameter28 VARCHAR2,
    p_parameter29 VARCHAR2)
    as
    v_req_id number;
    xml_layout boolean;
    begin
    fnd_request.set_org_id(fnd_global.org_id) ;
    -- you must call the ADD_LAYOUT API prior to submitting your Concurrent
    --Program if you are using XML Temlpate*
    xml_layout :=FND_REQUEST.ADD_LAYOUT('XXSFNT','XXSFNTOEXOEACK','en','US',
    'PDF');
    v_req_id := FND_REQUEST.SUBMIT_REQUEST(application => 'XXSFNT',
    program =>'XXSFNTOEXOEACK',
    argument1 => p_parameter1,
    argument2 => 'MSTK',
    argument3 => 'I',
    argument4 => p_parameter4,
    argument5 => p_parameter5,
    argument6 => p_parameter6,
    argument7 => p_parameter7,
    argument8 =>p_parameter8,
    argument9 => p_parameter9,
    argument10 =>p_parameter10,
    argument11 => p_parameter11,
    argument12 => p_parameter12,
    argument13 => p_parameter13,
    argument14 => p_parameter14,
    argument15 => p_parameter15,
    argument16 => p_parameter16,
    argument17 => p_parameter17,
    argument18 => p_parameter18,
    argument19 => p_parameter19,
    argument20 => 'SALES',
    argument21 =>'ALL',
    argument22 => p_parameter22,
    argument23=> p_parameter23,
    argument24=>'N',
    argument25=>p_parameter25,
    argument26=>p_parameter26,
    argument27=>'N',
    argument28=>'N',
    argument29=>'N');
    commit;
    end;
    /

    can any one help me..
     
  2. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    How are you calling this procedure ?? From APPS or PL/SQL ???
     
  3. manasa

    manasa Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Sorry,

    I am calling it from APPS.
     
  4. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    There is NO example here of how you are calling the REQUEST_SALES_ORDER procedure. No one can tell you what the issue is without that information.
     
  5. manasa

    manasa Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    When I am submitting a concurrent request of Create Sales Order Acknowledgement I am getting the error. I am attaching the snapshot of the exact error.

    Here is the procedure.

    CREATE OR REPLACE PROCEDURE APPS.XXSFNT_REQUEST_SALES_ORDER
    (p_parameter1 NUMBER,
    p_parameter2 VARCHAR2,
    p_parameter3 VARCHAR2,
    p_parameter4 VARCHAR2,
    p_parameter5 VARCHAR2,
    p_parameter6 NUMBER,
    p_parameter7 NUMBER,
    p_parameter8 DATE,
    p_parameter9 DATE,
    p_parameter10 VARCHAR2,
    p_parameter11 VARCHAR2,
    p_parameter12 VARCHAR2,
    p_parameter13 VARCHAR2,
    p_parameter14 DATE,
    p_parameter15 DATE,
    p_parameter16 DATE,
    p_parameter17 DATE,
    p_parameter18 DATE,
    p_parameter19 DATE,
    p_parameter20 VARCHAR2,
    p_parameter21 VARCHAR2,
    p_parameter22 VARCHAR2,
    p_parameter23 VARCHAR2,
    p_parameter24 VARCHAR2,
    p_parameter25 VARCHAR2,
    p_parameter26 VARCHAR2,
    p_parameter27 VARCHAR2,
    p_parameter28 VARCHAR2,
    p_parameter29 VARCHAR2)
    as
    v_req_id number;
    xml_layout boolean;
    begin
    fnd_request.set_org_id(fnd_global.org_id) ;
    -- you must call the ADD_LAYOUT API prior to submitting your Concurrent
    --Program if you are using XML Temlpate*
    xml_layout :=FND_REQUEST.ADD_LAYOUT('XXSFNT','XXSFNTOEXOEACK','en','US',
    'PDF');
    v_req_id := FND_REQUEST.SUBMIT_REQUEST(application => 'XXSFNT',
    program =>'XXSFNTOEXOEACK',
    argument1 => p_parameter1,
    argument2 => 'MSTK',
    argument3 => 'I',
    argument4 => p_parameter4,
    argument5 => p_parameter5,
    argument6 => p_parameter6,
    argument7 => p_parameter7,
    argument8 =>p_parameter8,
    argument9 => p_parameter9,
    argument10 =>p_parameter10,
    argument11 => p_parameter11,
    argument12 => p_parameter12,
    argument13 => p_parameter13,
    argument14 => p_parameter14,
    argument15 => p_parameter15,
    argument16 => p_parameter16,
    argument17 => p_parameter17,
    argument18 => p_parameter18,
    argument19 => p_parameter19,
    argument20 => 'SALES',
    argument21 =>'ALL',
    argument22 => p_parameter22,
    argument23=> p_parameter23,
    argument24=>'N',
    argument25=>p_parameter25,
    argument26=>p_parameter26,
    argument27=>'N',
    argument28=>'N',
    argument29=>'N');
    commit;
    end;
    /

    Thanks,
    Manasa
     

    Attached Files:

  6. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    How do you expect to call this procedure with all of the concatenation operations? You are not passing the required number of arguments to the procedure in a format the procedure can recognize. You seriously need to fix this.
     
  7. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    As an example of how you should call this:

    Code (SQL):
    SQL> CREATE OR REPLACE PROCEDURE wow_this_works(p_val1 IN NUMBER, p_val2 IN varchar2)
      2  IS
      3  BEGIN
      4          dbms_output.put_line('User submitted the following two parameter values: '||p_val1||'   '||p_val2);
      5  END;
      6  /
     
    PROCEDURE created.
     
    SQL>
    SQL> SET serveroutput ON SIZE 1000000
    SQL>
    SQL> EXEC wow_this_works('77'||','||'Yahooooooo!!!!!');
    BEGIN wow_this_works('77'||','||'Yahooooooo!!!!!'); END;
          *
    ERROR at line 1:
    ORA-06550: line 1, COLUMN 7:
    PLS-00306: wrong NUMBER OR types OF arguments IN CALL TO 'WOW_THIS_WORKS'
    ORA-06550: line 1, COLUMN 7:
    PL/SQL: Statement ignored

    SQL>
    SQL> EXEC wow_this_works(77,'Yahooooooo!!!!!');
    USER submitted the following two parameter VALUES: 77   Yahooooooo!!!!!
     
    PL/SQL PROCEDURE successfully completed.
     
    SQL>
    SQL> EXEC wow_this_works(p_val1=>77,p_val2=>'Yahooooooo!!!!!');
    USER submitted the following two parameter VALUES: 77   Yahooooooo!!!!!
     
    PL/SQL PROCEDURE successfully completed.
     
    SQL>