Hi everyone, I followed the below link to display blob content into a region and it is working fine. Display BLOB Contents (PDF, Images) into a Region in Oracle Apex Page - foxinfotech.in But i want display the blob content in modal dialog page , i tried creating modal dialog page with page item P3_ID and static content region to show the blob content and then passed parameter from the interactive report when click on ID column modal dialog page is opening with blank screen. Any help would be highly appreciated...
KamiyaContributor
Hi how to create report in my app like top users
Hello, Please help me figure out how I can format text in an Interactive Grid plain text field. I do have a column fetched from a table in an Interactive Grid column. The column in a table is a varchar2 type and has the text of up to 1000 characters. Now the requirement of an Interactive Grid is, that I want to display it in a bullet format if it has multiple sentences separated by '.' Example: Actual: Suzy provides the monthly financial reporting based on provided figures. The shareholders of the store have changed effective November 2021. How I want: Suzy provides the monthly financial reporting based on figures. The shareholders of the store have changed effective November 2021. Note: I have tried the solution by adding "replace(comments, '.', '<br>') comments" in select query in an interactive grid but it isn't working. Many Thanks, Bansari
Hi sir jii, How to right align the aggregated column value in oracle apex
shashiProfessional
Hi Sir jii, i have the sum of aggregate value for two columns need to calculate the average for these two values can u please suggest.
Hello, Please help me figure out how I can format text in a classic report plain text field. I do have a column fetched from a table in a classic report column. The column in a table is a varchar2 type and has the text of up to 1000 characters. Now the requirement of a classic report is, that I want to display it in a bullet format if it has multiple sentences separated by '.' Example: Actual: Suzy provides the monthly financial reporting based on provided figures. The shareholders of the store have changed effective November 2021. How I want: - Suzy provides the monthly financial reporting based on figures. - The shareholders of the store have changed effective November 2021. Note: Not necessary that bullets should be displayed with '-' but the purpose is only to separate the sentences so the user can read it sentence by sentence and not by paragraph. Many Thanks, Bansari
vaibhavContributor
Hi, In Oracle 19C database, can we transfer files in FTP/SFTP/SSHFTP using purely PL/SQL? Please give me link to accomplish this if possible. if not then please suggest the other ways. We want to process 500 files through sFTP daily. Regards Vaib
I installed oracle XE 21C on my pc i installed apex using following command apexins.sql apex_ts apex_ts temp /i/ apex_rest_config.sql i configure ORDS 22.2 using : java -jar dax.war --config c:\\dax_install\\config_dax install attached like is recorded video : https://drive.google.com/file/d/1V3r4HrQ2I7nwxVDCIQhihSmDz2ARTZ_e/view?usp=sharing i installed tomcat and deployed dax.war but i am getting error The request could not be mapped to any database. Check the request URL is correct, and that URL to database mappings have been correctly configured please guide me.
shashiProfessional
Hi sir jii, How to display null value as zero in IR report can you please suggest.
ShahulContributor
FRM-10142: The HTTP Listener is not running on %s at port %d . Please start the listener or check your runtime preferences