Hi,

I created oracle stored procedure and it runs successfully in sql plus.
Then i add procedure name in crystal report it gives error
Error name is:
ORA-01001: cursor invalid

stored procedure is

CREATE OR REPLACE PROCEDURE NEW_WORKER
(Person_Name IN VARCHAR2
,Person_age IN NUMBER
,Per_Lodging IN VARCHAR2 )
AS
BEGIN
INSERT INTO WORKER(Name,Age,Lodging)
values
(Person_name,person_age,per_lodging);
End;

Please help me out.
Thanks.