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.
Discy Latest Questions
swamy kumarContributor
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;
BansariProfessional
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
HaseebContributor
Hi I want to get client desktop name in oracle apex . I am unable to find solution
I have a SQL Query inside button that will return multiple data. The Interactive Grid also got it own SQL Query. How do I populate/add these data into an Interactive Grid that already have data without replacing existing data in the Interactive Grid?.
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)".
Greg GContributor
I have a colleague that is using a collection in one of his pages. However, when he runs the query: Select * from apex_collections; No rows are returned. Any idea why no rows are found? Thanks.
bob_finlandersContributor
I have been struggling to find a way how to implement this task Below is the GUI I have designed I have 2 reports on my page Interactive grid report [ Name : Employees ] Interactive report [ Name : selected ] Whatever I select from first report should be shown on second report [ selected ] on checkbox is tick I have refer this blog but no luck : https://www.foxinfotech.in/2019/10/oracle-apex-interactive-grid-get-selected-rows-example.html Any solution or video demonstration is much appreciated
Hi sir jii, How to hide Rows in IR Report when column values is null. Can you please suggest.
bob_finlandersContributor
I am running out of time because of this task, No where I am able to find appropriate answers for this task. I have a interactive grid report and in which I have enabled the editing option. <Interactive grid -> attributes -> editing -> enabled /> After enabling the editing option -> The checkbox became available for me like below When I select multiple checkbox their details should be inserted to table I posted same question on Stackoverflow but no solution Can you please check and provide your solution or input Stackoverflow question : https://stackoverflow.com/questions/73166100/iterate-through-selected-checkbox-oracle-apex?noredirect=1#comment129221060_73166100 Thanks & Regards, Bob finlanders