Hi Straut
The below code gets Complied but when i try to execute the code it is gives me the Error saying
An Error was encountered performing the requested operation:
ORA-06550:line 10, column 3:
PLS-00306:wrong number or types of arguments in call to 'INSERTCOMMENTS_NEW'
ORA-06550:line 10, Column 3:
PL/SQL:Statement ignored
ORA-06512:at line 58
Vender Code 6550
create or replace
PROCEDURE INSERTCOMMENTS_NEW (
N_HATID IN NUMBER,
N_POINTS IN VARCHAR2 DEFAULT 255,
N_QETYPE IN VARCHAR2 DEFAULT 255,
p_cursor out SYS_REFCURSOR)
IS
COUNT_COMMENTS NUMBER := 0;
BEGIN
SELECT COUNT(*) INTO count_comments
FROM CCM_REPORT_USER.POINTS_QETYPE_COMMENTS
WHERE CCM_REPORT_USER.POINTS_QETYPE_COMMENTS.HATID = N_HATID;
IF(count_comments = 0) THEN
INSERT INTO CCM_REPORT_USER.POINTS_QETYPE_COMMENTS (HATID, POINTS, QETYPE)
VALUES (N_HATID , N_POINTS , N_QETYPE);
ELSE
UPDATE CCM_REPORT_USER.POINTS_QETYPE_COMMENTS
SET CCM_REPORT_USER.POINTS_QETYPE_COMMENTS.POINTS = N_POINTS,
CCM_REPORT_USER.POINTS_QETYPE_COMMENTS.QETYPE = N_QETYPE
WHERE CCM_REPORT_USER.POINTS_QETYPE_COMMENTS.HATID = N_HATID;
END IF;
open p_cursor for SELECT HATID FROM POINTS_QETYPE_COMMENTS ;
END;
Kindly suggest me on this thanks a lot in advance