5 Replies Latest reply: Feb 7, 2013 9:38 PM by vyuvaraj RSS

    Rowid does not work with apex_applicaton

    vyuvaraj
      Here is my code:

      begin
      for i in 1..htmldb_application.g_f01.count loop

      update dppr_admin.permission_case
      set responder_gpin = 'pot'
      -- where rowid = apex_application.g_f02(i);
      where rowid='AAAQqFAAKAAACCDAAe';
      commit;
      end loop;
      end;

      it works fine if I pass rowid with an value, but fails when i pass rowid = apex_application.g_f02(i);. The PL/SQL Code executed without any issues.

      can someone help me if I missing anything here?