![]() ![]() ![]() When you create a Dynamic Action, you have to enter the Items to Submit and Items to Return below the PL/SQL Code Textarea, to set the correct Session State without submitting the complete page.Īnother solution without the Dynamic Action would be to simply create a Page process after Submit and Insert your Data to The Database. MULTIMEDIA_COMPONENTES_HMI.COSTO * :P4_CANTIDAD into :P4_TEXTBOX The PL/SQL Query could do Something like display all the changed data, and insert the new information in the database. This Dynamic Action could have a TRUE Trigger with a execute PL/SQL Code Action. If you want to load the values to the textbox as the Query is executet, and display the result immediately for the user, you have to use a Dynamic Action, triggered by a Button or a value Change Event on the Items you referred to: P4_CANTIDAD or P4_COSTO. ![]() This allows the development team, to manage the centralized LOVs via SQL DML management, instead of having to log into APEX.There are more than one Solution for this question. This gives maximum flexibility to control the data that is being returned for the LOV and any future maintenance/modifications can be done on the LOV. Note: You can alter this function signature to match any complex SQL logic, query filters, join conditions, sort order, etc… and apply those onto building the dynamic SQL string that’ll be finally returned as the LOV driving query. The code below shows a simple example of how the SQL is extracted and returned to the LOV from the SQL defined in the APP_LOV_LOOKUP table. ’SELECT country_name d, country_id r FROM countries c WHERE active = ‘||’’’’||’Y’||’’’’||’ ORDER BY country_name’, SELECT lookup_seq.nextval, ‘COUNTRY’,’COUNTRY’,’Country Name/ID Lookup Definition’, Lookup_id, lookup_code, lookup_meaning, lookup_description, lookup_query, lookup_comments You should write SQL Scripts to INSERT your LOV queries into the APP_LOV_LOOKUP table. While building the dynamic SQL for the LOV, your PL/SQL API call has to build the select query from each of the column values.Įxample record Ddfined for Countries LOV – The INSERT statement below sets up the dynamic SQL query into the APP_LOV_LOOKUP table. ![]() However, you can choose to extend this and add additional columns for specific values such as: display_col, return_col, from_object, order_by_col, etc… Note: For the simple demonstration of the above approach, the entire query string column – lookup_query – is defined in the above table as a single column. LOV Storage Table Definition – APP_LOV_LOOKUP APP_LOV_LOOKUP ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |