how to call database package , after saving the Data [message #629185] |
Thu, 04 December 2014 04:09 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/a59247482a11edb9544247f102223e8d?s=64&d=mm&r=g) |
mist598
Messages: 1195 Registered: February 2013 Location: Hyderabad
|
Senior Member |
|
|
Hi all,
I am inserting data into the Table through Form , i have one flag called Update_flag, i am checking and clicking on the SAVE menu from menu option.
After need to fire Database package,for that i called in the key-comit trigger on database block
Ex:
Inserting data into the Table through form and also checking the Update_flag and clicking on the SAVE Menu ,but i am not getting any messages like
'1 record is inserted ' , i am getting only after closing the Form
and also my package is not firing
Can you please help me?
Thanks
|
|
|
|
|
|
|
|
|
|
|
|
Re: how to call database package , after saving the Data [message #629202 is a reply to message #629201] |
Thu, 04 December 2014 06:43 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13925 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
do_key('commit_form') fires the key-commit trigger. So that wouldn't be a good idea.
Just use commit_form.
However, there are ways of saving data that bypass key-commit (exit the form and it'll ask if you want to save changes. If you click on yes it'll save the changes without using key-commit). So you shouldn't use it at all.
What is procedure for?
|
|
|
|
|
|