DML in QUERY_ONLY Form

I know that when I call a form (e.g. using call_form) I can set the mode to QUERY_ONLY so that users cannot insert/delete/update records in called form. My question is if I issue a DML statement in a procedure e.g.  

begin
insert into table_name values (value1, value2,...);
commit;
end;

Would above DML statement insert values in to the table?

Thanks in advance!
McLeanISAsked:
Who is Participating?
 
Muhammad Ahmad ImranDatabase DeveloperCommented:
no, it would not
0
 
ajexpertCommented:
Yes


It will insert the values in table if you execute the following block
begin 
insert into table_name values (value1, value2,...); 
commit; 
end;

Open in new window

0
 
schwertnerCommented:
i guess it wiil not work. the result will be error ...

But the best answer will give the experiment. It is so easy ...
0
 
ajexpertCommented:
@schwertner:
Can you please tell why it wont work?

The author is stating
" I issue a DML statement in a procedure e.g.  "
0
 
McLeanISAuthor Commented:
Thanks for the inputs.

ajexpert, what I mean in question is would a DML statement in a QUERY_ONLY form work? I tested it  and it doestn't work for me but it seems working for someone else I saw. That's the reason why I subbmitted a question here.

Thanks again!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.