ORA-01001: invalid cursor
597601Dec 5 2008 — edited Dec 5 2008Hi
I get the following error message(ORA-01001: invalid cursor ORA-06512: at 15 "Save_Filter", line ORA-06512) in the below procedure.
PROCEDURE Save_Filter
(
i_Filter_Name VARCHAR2,
i_Filter_Comment VARCHAR2,
i_Label VARCHAR2,
i_Label_Value VARCHAR2,
i_User VARCHAR2
)
AS
x_Seq NUMBER;
BEGIN
SELECT Filter_Sequence.NEXTVAL INTO x_Seq FROM dual;
if (length(Label_Value) < 8000) then
INSERT INTO FILTER_Data(
Filter_Name, Filter_Comment, Label, Label_Value1, Label_Value2, i_User, Filter_id, Saved_Date)
VALUES (
i_Filter_Name, i_Filter_Comment, i_Label, substr(i_Label_Value1, 1,4000), substr(i_Label_Value2,4001,4000), i_User, x_Seq, sysdate);
end if;
COMMIT;
END;
i am using ORACLE Version: 10.2.0.2.20
I don't use cursor in this procedure but get cursor related error. Someone help me to solve the above problem