1 Reply Latest reply: May 6, 2013 5:38 AM by HamidHelal RSS

    PLS-00306: wrong number or types of arguments

    1007273
      Hey,

      I am creating a function to concate varchar to be used as BLOB.

      CREATE OR REPLACE TYPE myTableType as table of varchar2(4000);

      CREATE OR REPLACE FUNCTION F_VARCHAR_TO_BLOB (input_table_of_varchar myTableType) RETURN BLOB IS
      PRAGMA AUTONOMOUS_TRANSACTION;
      v_blob BLOB;
      BEGIN
      FOR i IN 1..input_table_of_varchar.COUNT
      LOOP
      v_blob := v_blob || input_table_of_varchar(i);
      END LOOP;
      RETURN v_blob;
      END;

      Now while compiling the function i am getting the following error:
      7/12 PLS-00306: wrong number or types of arguments in call to '||'

      Can someone please check what i am doing wrong here.

      Regards
      EPATVIS
        • 1. Re: PLS-00306: wrong number or types of arguments
          HamidHelal
          Hi, EPATVIS
          Welcome to the Oracle Forums. Please take a few minutes to review the following:

          <ul>
          <li>Oracle Forums FAQ
          <li>Before posting on this forum please read
          <li>10 Commandments for the OTN Forums Member
          <li>How to ask questions the smart way
          </ul>

          Following these simple guidelines will ensure you have a positive experience in any forum; not just this one!
          user10178524 wrote:
          Hey,

          I am creating a function to concate varchar to be used as BLOB.

          CREATE OR REPLACE TYPE myTableType as table of varchar2(4000);

          CREATE OR REPLACE FUNCTION F_VARCHAR_TO_BLOB (input_table_of_varchar myTableType) RETURN BLOB IS
          PRAGMA AUTONOMOUS_TRANSACTION;
          v_blob BLOB;
          BEGIN
          FOR i IN 1..input_table_of_varchar.COUNT
          LOOP
          v_blob := v_blob || input_table_of_varchar(i);
          END LOOP;
          RETURN v_blob;
          END;

          Now while compiling the function i am getting the following error:
          7/12 PLS-00306: wrong number or types of arguments in call to '||'
          You post in wrong forum. please post at {forum:id=75}. Before posting there close this thread marking as answered.