APEX

Team,

I am writing a simple HTML DB application which allows developers to update the user_tab_comments table. We are doing this in order to build an in-house data dictionary. When testing, I consistantly get the following error:

"ORA-06550: line 4, column 13: PL/SQL: ORA-01031: insufficient privileges ORA-06550: line 4, column 6: PL/SQL: SQL Statement ignored"

The code behine the Update button is rather simple. See for yourself:

for i in 1..htmldb_application.g_f01.count
loop
if htmldb_application.g_f31(i) is not Null then
update user_tab_comments
set comments = htmldb_application.g_f01(i)
where table_name = htmldb_application.g_f02(i);
end if;
end loop;


We would really like for our users/developers to maintain the data dictionary by themselves!!! Any clues?

Thanks,
Howard