Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01001: invalid cursor

597601Dec 5 2008 — edited Dec 5 2008
Hi

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 2 2009
Added on Dec 5 2008
2 comments
902 views