[Oracle connector] ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to

[Oracle connector] ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to

  
Forge Component
(12)
Published on 2013-04-01 by Francisco Menezes
12 votes
Published on 2013-04-01 by Francisco Menezes

hi there i have a package in Oracle and i am using an oracle connector "Oracle.connector.P9-0.1.0":

CREATE OR REPLACE PACKAGE BODY hello
AS
   PROCEDURE MyProcedure
   IS
      TmpVar   NUMBER;
   BEGIN
      DELETE FROM OSADMIN.IBOXUSER employees
            WHERE employees.id = 1;

      COMMIT;
   END;

   PROCEDURE MyProcedureinput (v_id IN NUMBER)
   IS
      TmpVar   NUMBER;
   BEGIN
      DELETE FROM OSADMIN.IBOXUSER employees
            WHERE employees.id = v_id;

      COMMIT;
   END;
END hello;
/

when i execute using MyProcedure it success. However for MyProcedureinput, it fails showing that message..wrong number or types of arguments in call to

I have an input with local variable named "idku" and i use it in the parameter of the connector function: toobject(idku).

tq.