APEX

Hi All,

We are getting error while executing below code.

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;

report error

ORA-01002: fetch out of sequence

ORA-06510: PL/SQL unhandled user-defined exception

regards,

Vinay