ERRor message

From: John Ammon <bankye1_at_hotmail.com>
Date: 8 Dec 2001 14:05:39 -0800
Message-ID: <e73d4940.0112081405.1ec8eb6a@posting.google.com>

I am creating the below procedure below: When I test it with this test I get the error message below. Can someone tell me what I am doing wrong:

BEGIN
  Add_grade_type(&grade_type_code', '&description'); END; I get this error:

++++++++++++++++++++++++++++++++++++++++++++++++++++++

ERROR at line 2:
ORA-06550: line 2, column 3:
PLS-00306: wrong number or types of arguments in call to 'ADD_GRADE_TYPE'
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored

---

CREATE OR REPLACE PROCEDURE Add_Grade_Type (pi_grade_type_code IN GRADE_TYPE.grade_type_code%TYPE,  pi_gt_description IN GRADE_TYPE.description%TYPE,  o_return_code OUT INTEGER)
AS

   v_gt_type_code GRADE_TYPE.grade_type_code%TYPE;
   v_gt_description GRADE_TYPE.description%TYPE;
   v_gt_dummy VARCHAR2(2);

BEGIN
   v_gt_type_code := pi_grade_type_code;    v_gt_description := pi_gt_description;   SELECT grade_type_code

     INTO v_gt_dummy
     FROM GRADE_TYPE
    WHERE grade_type_code = v_gt_type_code;
	DBMS_OUTPUT.PUT_LINE('The GRADE TYPE code '||v_gt_type_code||


      ' IS already IN the DATABASE AND cannot be'||

      ' reinserted.');

 EXCEPTION
   WHEN NO_DATA_FOUND
   THEN

      INSERT INTO GRADE_TYPE
	  (grade_type_code,
description,created_by,created_date,modified_by,modified_date)
      VALUES(v_gt_type_code, v_gt_description, USER, SYSDATE,
        USER, SYSDATE);

   o_return_code := 0;
  WHEN OTHERS
 THEN
 DBMS_OUTPUT.PUT_LINE ('Error IN finding GRADE TYPE: ' || pi_grade_type_code);
 o_return_code := SQLCODE;
 END Add_Grade_Type;
/

---

Thank you Received on Sat Dec 08 2001 - 16:05:39 CST