This discussion is archived
5 Replies Latest reply: Feb 7, 2013 7:38 PM by vyuvaraj RSS

Rowid does not work with apex_applicaton

vyuvaraj Newbie
Currently Being Moderated
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?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points