Hi sir jii, I created an classic report and choose template as card type and able to display image on page but the problem is images are varying with different size can you please suggest how to control size of image.
HI, how to download a zip file which is stored in directory with the button click in oracle apex I had written a process to call it but throwing the error as syntaxError: Unexpected token 'P', "PK"... is not valid JSON.. Here is my piece of code written in processing: declare Lob_loc bfile; begin Lob_loc := bfilename('ABC_DIRECTORY','data file.zip'); OWA_UTIL.MIME_HEADER( 'application/zip', FALSE ); htp.p('Content-Disposition: attachment; filename="'||'data file.zip"'); owa_util.http_header_close; wpg_docload.download_file(Lob_loc); apex_application.stop_apex_engine; exception when others then raise_application_error(-20002, SQLCODE||' — '||SQLERRM); apex_application.stop_apex_engine; end;
Hello, I want to write a plsql procedure block to generate a CSV file using manual data as well as data from one table, using utl_file package and cursors. Please check the attachment. The table has records of a few lines only which has data and I want to add time column(column A) as you can see in the attachment where it will have time data after every 5 mins and for any time if a table has records, the procedure has to take the data into the file. Thanks, Bansari
Hi all, could you please guide me through the process of implementing a multiple approval workflow using Apex? For example, with Purchase Order, if purchases Order is created, it should first be approved by his Supervisor, then Finance Team, then Chief Accountant(if above $10,000) and finally the Purchase Manager for approval. How can we achieve it? Thanks
Hello Apex Expert, In Apex, I have Master Detail form where Detail part is created using Interactive Grid. This is one go form i.e. entering master and detail record on the same form. I do not have Master Report. So when I click the Save button I want to save the data in Master table as well as in Detail table. I have tried manual PL/SQL Code process but when trying to enter the data in Detail table it raises an error saying "Cannot enter NULL value in Master_Id". I have no idea how can I capture the Master_Id for manual IG Process? Your help would be greatly appreciated. Kind Regards,
How can I call Oracle Database stored procedure getting in one parameter on click of a Button in Oracle APEX? . It has nothing to return back to APEX. I should work just like a "Exec Procedure_Name (Parameter)".
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...