Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 503
  • Last Modified:

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!
0
McLeanIS
Asked:
McLeanIS
1 Solution
 
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
 
Muhammad Ahmad ImranDatabase DeveloperCommented:
no, it would not
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

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now