❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up 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.
Where to handle errors in process or store procedure ?
Vinish Kapoor
From the PL/SQL dynamic action set the returned error message value to a hidden page item using the apex_util.set_session_state method. And write a dynamic action on that hidden item for change event and show the error message using the JavaScript alert.
From the PL/SQL dynamic action set the returned error message value to a hidden page item using the apex_util.set_session_state method. And write a dynamic action on that hidden item for change event and show the error message using the JavaScript alert.
See lesshow to add date facet in faceted search
Vinish Kapoor
You need to get the date column as varchar2 and use the input field instead. For example: select ORDER_ID, CUSTOMER_ID, ORDER_TOTAL, to_char(trunc(ORDER_TIMESTAMP), 'mm-dd-yyyy') od, USER_NAME, TAGS from DEMO_ORDERS Now for the OD column, use the input field and for the database column property, speRead more
You need to get the date column as varchar2 and use the input field instead. For example:
Now for the OD column, use the input field and for the database column property, specify the OD column. Then you would be able to enter a date using the same format specified in the SQL query to filter the result at runtime.
See lessHow to call apex_mail.send from outside of apex 20?
Vinish Kapoor
You can use apex_mail in the database procedure as you use in Oracle Apex, but instead, use UTL_SMTP to send mail outside of Apex is better.
You can use apex_mail in the database procedure as you use in Oracle Apex, but instead, use UTL_SMTP to send mail outside of Apex is better.
See lessHow to call ajax callback process in modal dialog page?
Vinish Kapoor
On your dialog page, create a region as URL type, and in the attributes section, specify the Ajax application URL. Then it should load.
On your dialog page, create a region as URL type, and in the attributes section, specify the Ajax application URL. Then it should load.
See lessHow to save and remember user on login page ?
Vinish Kapoor
In Oracle Apex, there is an item P9999_REMEMBER created by default on the login page. And has a process code as below: apex_authentication.send_login_username_cookie ( p_username => lower(:P9999_USERNAME), p_consent => :P9999_REMEMBER = 'Y' ); So if your page is not having this item, you can cRead more
In Oracle Apex, there is an item P9999_REMEMBER created by default on the login page. And has a process code as below:
So if your page is not having this item, you can create an item P9999_REMEMBER and then create a process and add the above code. It will then function as required.
See lessHow to get confirmation message for Logout
Vinish Kapoor
Create a modal dialog page to confirm the logout action. And if the user select Ok then execute the following PL/SQL code: apex_authentication.logout(:SESSION, :APP_ID); Now, go to Shared Components > Navigation List and edit the Sign Out list entry. Change the Target type to Page in this ApplicaRead more
Create a modal dialog page to confirm the logout action. And if the user select Ok then execute the following PL/SQL code:
Now, go to Shared Components > Navigation List and edit the Sign Out list entry.
Change the Target type to Page in this Application and specify the dialog page you created.
See lessGenerate from Interactive Report and Insert into DB Table
Vinish Kapoor
You can test for the BLOB by storing it in a temporary table and then check the BLOB data from that table. Then you will come to know if your BLOB is ok. And if the BLOB is ok, then the issue is with your email program.
You can test for the BLOB by storing it in a temporary table and then check the BLOB data from that table. Then you will come to know if your BLOB is ok.
And if the BLOB is ok, then the issue is with your email program.
See lesshow can i send report direct on printer ?
Vinish Kapoor
Use the Google cloud printing option. After this, you just need to send the BLOB or CLOB to a mail id configured with the Google cloud printing service.
Use the Google cloud printing option. After this, you just need to send the BLOB or CLOB to a mail id configured with the Google cloud printing service.
See lessJava call terminated by uncaught Java exception:
Vinish Kapoor
You need to give permissions using dbms_java.grant_permission() method. Below is an example: Login as SYS or System, then execute the following PL/SQL block by making the changes according to your schema and hostname: Begin dbms_java.grant_permission('YourSchema', 'java.net.SocketPermission', 'yourHRead more
You need to give permissions using dbms_java.grant_permission() method. Below is an example:
Login as SYS or System, then execute the following PL/SQL block by making the changes according to your schema and hostname:
See lessHow to escape "&" in checksum of URL?
Vinish Kapoor
Set the following setting for page no. 1: Open your page then go to Settings > Security > Page Access Protection to Unrestricted.
Set the following setting for page no. 1:
Open your page then go to Settings > Security > Page Access Protection to Unrestricted.
See less