Save Tab Form with Procedure Tweet
Easily save changes in a Tab Form with a procedure
Normaly there is only the ApplyMRU process in a tabular form available to save the changes made. With this plugin you can easily send the changes to a procedure and process it there.
No need to think about the variables APEX_Application.g_fxx and how they are mapped to the columns.
The images are here:
Tabular Form Procedure
Do you have a question about this Plugin? Want to write a Review or Comment?
Reviews / Questions / Comments are e-mailed to the author of the Plug-in.
I am ready to fill in the blanks with the code, and cannot figure out what is p_chk$01. Is it the mode, insert, update, delete, and if yes, how do I pass the values to it ?, I wish to do different things in updated and insert modes ( for insert I would like to put a row in another table with one of the parameters being a page item).
Thank you so much!
Then it looks like the form values are being passed to the wrong procedure parameters. I confirmed this with a test update procedure that logged the parameter values. My first guess was that this plug-in would work if the database table was in the Apex workspace schema, but I didn't take any more time to test that theory, as it wouldn't be useful to me anyway.
I just tried installing your plug-in, but it references a package that I'm guessing is custom to your setup? Line 111 of the PL/SQL Code source references PKG_UTILS.LOG function, which isn't provided on my Oracle 11gR2 database with the Apex 4.0.1 installation.
I'll just comment it out or change it to use a local logging function I've written.
Thanks for providing this,
you can run the process depending on the button that was pressed. What happens in the procedure is your choice. If you do an update, insert or delete in the procedure is your choice. Of course you have to put some code into the NULL in Step14.jpg.
My English is not good. Question.
How do I know the kind of statement that I use, INSERT, DELETE, UPDATE?. Is there a state that should be handled on the block?
sorry the export was from a 4.1 system where i tried the plugin. I uploaded an export from my 4.0 development system now. So I hope this should work now on 4.0 and 4.1
Version 4.0 can not create step 4 (associate plugin) and your workspace is 4.1 BWC this utility is not in version 4.0.
Thank you for your attention.
The plugin is also for 4.0
I use it on 4.0 in different projects.
Do you have problems in 4.0 ?
|Powered by Sigsiu.NET|