ORA-01002: fetch out of sequence
PROCEDURE IS_CLIENT_LOGGED_IN (P_CLIENT_NUM Varchar2,P_CURSOR out SYS_REFCURSOR ,P_COUNT OUT NUMBER,P_ERROR out Varchar2) AS cur_rec Varchar2(1024); BEGIN BEGIN Open P_CURSOR FOR SELECT ID FROM tbl_registration WHERE tbl_client_id = P_CLIENT_NUM AND tbl_logout_date is null; LOOP FETCH P_CURSOR INTO cur_rec; EXIT WHEN P_CURSOR%notfound; P_COUNT := P_CURSOR%rowcount;--will return row number beginning with 1 END LOOP; EXCEPTION WHEN OTHERS THEN P_ERROR := 'Unable to select Data from tbl_registration' ||SQLERRM; END; END IS_CLIENT_LOGGED_IN;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)