Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2007

    Question Unanswered: PLS-00306: wrong number or types of arguments in call to

    I am getting error
    PLS-00306: wrong number or types of arguments in call to

    I have package and one of its procedure has out parameter of type table of clob
    The issue is when I execute this procedure it fails with PLS-00306: wrong number or types of arguments in call to
    I am using following block to execute my proc

    type var_array_xml is table of clob;
    var var_array_xml:=var_array_xml();
    v_retval_shipment_main number;
    v_errm_shipment_main varchar2(2000);
    test_shipment_xml.shipment_main(var,v_retval_shipm ent_main,v_errm_shipment_main);

    Procedure test_shipment_xml.shipment_main has first out parameter of type var_array_xml is table of clob
    when I remove this parameter and print the values in the procedure it shows me proper output but I need to output a variable of type table of CLOB.

    Can somebody please help me with this.

    Thanks in advance,

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    Below is what we know:
    1)PLS-00306: wrong number or types of arguments in call to

    Below is what we don't know:
    1) Operating System (OS) name
    2) OS version
    3) Oracle version to 4 decimal place
    4) The actual code that is part of the problem.
    5) How to reproduce the problem for ourselves.

    Therefore You're On Your Own (YOYO)!
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Nov 2007
    ok sorry for that but good news is I got my solution just now.
    Actually while calling procedure which uses type/collection as argument we should use the type declared in the package itself and not locally declared type of similar type.Because separate types defined in PL/SQL are not considered to be the same type, even if they are identical.So when I used varaible of type of package it worked.Thanks for your efforts for looking into this.

  4. #4
    Join Date
    Jul 2010

    can you describle more on this?

    Hi Vaishali,

    I am facing the similar problem. I am not clear with the solution you provided.

    I am using a type table of varchar2tabtyp:
    type varchar2tabtyp is table of varchar2(2000) index by binary_integer;
    null_varchar2tab varchar2tabtyp;

    I have written the above in package1's spec. But i am calling this type for another package spec. So it is like the below:

    procedure proc2(
    var1 in varchar2 default null
    var2 package1.varchar2tabtyp default package1.null_varchar2tab
    var3 package1.varchar2tabtyp default package1.null_varchar2tab

    and then I am calling in the package2 body, as follows:

    Please let me know if you can help me out in this.

    Thanks a lot in advance.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts