❇️ 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.
How to display image in Bi Publisher report by querying from Oracle Apex
Vinish Kapoor
Currently, I can't see my computer, but you can try once more by changing the field code as below: <fo:external-graphic src="{IMAGE_DATA}" content-width="scale-to-fit" width="100%"/> Try once with curly braces and without curly braces.
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.
how 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
How 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.
How 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.
How 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
How 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
Generate 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.
how 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.
Java 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