Hey, Dev!
Are you looking for a forum full of active developers to help you?
So if you want to:
➡️ Get answers for your development issues
➡️ Help others
➡️ Write an article
➡️ Get rewarded for your active participation
Then this place is just for you and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Apex Collection: how to have actual column names instead of C001, C002...
Vinish
Select your classic report and then go to Attributes > Heading. Then choose the heading type as PL/SQL Function body and put the following code in it: DECLARE c NUMBER; d NUMBER; col_cnt INTEGER; f BOOLEAN; rec_tab DBMS_SQL.DESC_TAB; col_num NUMBER; v_columns varchar2(1000); PROCEDURE print_rec(rRead more
Select your classic report and then go to Attributes > Heading. Then choose the heading type as PL/SQL Function body and put the following code in it:
Here is the app example: SQL Command.
See lessCalling Application_process on a Modal page
Vinish
Try to use region URL type and place the application process in the Attribute > URL property. Also, specify the width and height as width="99%" height="1000" in iframe attribute property.
Try to use region URL type and place the application process in the Attribute > URL property. Also, specify the width and height as width="99%" height="1000" in iframe attribute property.
See lessHow to prevent year entering as 0022 in oracle forms 6i
Vinish
You will have to put the validation to prevent it. For example: Begin if substr(to_char(:yourblock.dateitem, 'dd/mm/yyyy'), 7, 2) = '00' then -- give message raise form_trigger_failure; end if; End;
You will have to put the validation to prevent it. For example:
How to display HTML from table with PL/SQL Dynamic Content region?
Vinish
I am assuming that your HTML data is stored in the CLOB data. You can check the below link to how to display clob data in the Oracle Apex region. Display CLOB data in a Region. It displays the data on click, you can modify it to display on page load or any other event.
I am assuming that your HTML data is stored in the CLOB data. You can check the below link to how to display clob data in the Oracle Apex region.
Display CLOB data in a Region.
It displays the data on click, you can modify it to display on page load or any other event.
See less"Actions" in Dynamic Action are not running in Sequence
Vinish
Dynamic actions will be executed in the sequence they created. But executing JavaScript code is a client-side action, and the PL/SQL one is server-side. DA will execute the JS first and then will immediately execute the PL/SQL. So both will execute at almost the same time. To execute PL/SQL code aftRead more
Dynamic actions will be executed in the sequence they created. But executing JavaScript code is a client-side action, and the PL/SQL one is server-side. DA will execute the JS first and then will immediately execute the PL/SQL. So both will execute at almost the same time.
To execute PL/SQL code after JS, you can use the following trick:
From JS code, set a value of a hidden item (create a new hidden item) and write a DA to execute PL/SQL code on the change value of that hidden item.
Using this method, the JS code will execute first, and when that code sets a value of a hidden item, then only PL/SQL code will run.
Interactive Report Summary based on filter
Vinish
Instead of the default search bar, try to build them a custom search bar for the interactive report. That way you would be able to access the searched values.
Instead of the default search bar, try to build them a custom search bar for the interactive report. That way you would be able to access the searched values.
See lessHow to Show numeric key paid on number field
Vinish
Check this tutorial: Add jQuery.Numpad to Numeric Fields.
Check this tutorial: Add jQuery.Numpad to Numeric Fields.
See lessORDS: An unexpected error with the following message occurred: null
Vinish
Try with the following code: Declare b_blob blob; p_cod_input varchar2(50) := 'INLP'; n_len number; BEGIN cpl_load.xlsx_builder_Pkg.clear_workbook; -- cpl_load.xlsx_builder_pkg.new_sheet ('test'); cpl_load.xlsx_builder_pkg.query2sheet (p_sql => 'select * from emp', p_sheet => 1); b_blob := cplRead more
Try with the following code:
See lessHow to display login name in application navigation bar?
Vinish
What computation point you selected? Maybe you need to logout and login again to see the effect. Or select the computation point before header.
What computation point you selected?
Maybe you need to logout and login again to see the effect.
Or select the computation point before header.
See lessOracle APEX Set CSS style to Red color for numbers less than 0 with JAVASCRIPT
Vinish
This is great 👍. So finally it can be called as: $('input').each(function(){ if ($.isNumeric(getNumberFromCurrency($v(this)))) { if (parseFloat(getNumberFromCurrency($v(this)),10) < 0) { $(this).css({'color':'red'}) } } }).on('blur', function() { if ($.isNumeric(getNumberFromCurrency($v(this))))Read more
This is great 👍. So finally it can be called as:
See less