Hi all,
In below code we are facing 2 errors.
ORA-01002: fetch out of sequence
ORA-06510: PL/SQL: unhandled user-defined exception
Please suggest.
DECLARE
vRow binary_integer;
vrowold binary_integer;
v_person VARCHAR(100);
v_login VARCHAR(50);
v_org VARCHAR(50);
v_apex VARCHAR(50);
v_role VARCHAR(50);
v_keep VARCHAR(50);
i INTEGER;
v_review VARCHAR(100);
v_sysdate TIMESTAMP;
-- reviewer und sysdate erfassen
CURSOR c_rev
IS
SELECT Email FROM apex_workspace_apex_users WHERE user_name = :APP_USER;
CURSOR c_sysdate
IS
SELECT to_timestamp(TO_CHAR(sysdate,'DD.MM.YYYY HH24:MI:SS'), 'DD.MM.YYYY HH24:MI:SS')
FROM dual;
BEGIN
--reviewer und sysdate in variablen schreiben
OPEN c_rev;
FETCH c_rev INTO v_review;
CLOSE c_rev;
OPEN c_sysdate;
FETCH c_sysdate INTO v_sysdate;
CLOSE c_sysdate;
--v_review:= v_review || ' ' || v_sysdate;
Vrowold :=-1;
-- im r25 sofort löschen skript
FOR i IN 1..apex_application.G_F40.count
LOOP
vRow := apex_application.G_F40(i);
--IF vRow <> vrowold THEN
--vRow := apex_application.G_F37(i);
Delete From Plm_T_URI_LOGIN_CHANGES
Where Plm_T_URI_LOGIN_CHANGES.login = Apex_Application.G_F35(Vrow);
COMMIT;
End Loop;
END;