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
Discy Latest Questions
I was unable to make the button in a parent page hide when i click a button in a corresponding modal page after the modal dialog closes. I used many methods but it only requires me to refresh parent page to hide the button. I also tried executing javascript and server-side code in dialog close in dynamic action but in vain. Please help me find a solution.
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
Sbonelo MchunuProfessional
Hi Is it possible to select a local variable in a sql query when using Function Body PLSQL returning SQL query type. Example: declare l_query varchar2(4000); l_practice varchar2(100); cursor c1 is select * from TABLE; begin for r1 in c1 loop //some code here l_practice := l_practice + r1.c001; end loop; l_query :='select '|| l_practice||' from TABLE'; return l_query; end;
where wrapper script is used with plsql.and reference material/link to go through?
ChaitanyaProfessional
Hello,I have one excel file with headings in it. I have one form which contains all fields related to excel file So what I want to do is when users fills the form and submits it should automatically open excel file filled with the data entered in form. Thanks in advance
Hello Everyone I Have Created a Form in my oracle apex application in which i'm Uploaing multiple images into database. I Want To Upload Images In compress Format (.zip) into database. Means user Selects Images like .jpg, .png etc. and when he uploads Images it Should be Converted Into zip and then store into database Thanks in Advance.
Hyy Vinish sir and dear all i have intercatve grid on my page i have many data as you can see what i want to do is update selected data . for example if user selects 3 data and press save button, the 3 data should get updated. the update action i want to perfom is something like this if :old_rate > 0 and :new_rate > :old_rate then UPDATE TABLE A SET audit_yn='Y', audit_date=to_date(sysdate,'dd/mm/rrrr'), auditor=:APP_USER, authority=XYZ', auth_date=to_date(sysdate,'dd/mm/rrrr'), auth_yn='Y' WHERE ref_no = :ref_no and to_date(to_char(ref_date,'dd/mm/yyyy'),'dd/mm/yyyy') = to_date(:ref_date,'dd/mm/rrrr'); else UPDATE A SET audit_yn='Y', audit_date=to_date(sysdate,'dd/mm/rrrr'), auditor=:APP_USER end if; Thanks in advance..
ChaitanyaProfessional
Dear Vinish Sir i'm trying to send email from my apex 19.1,i'm getting following error ORA-04063: package body "APEX_190100.WWV_FLOW_MAIL" has errors ORA-06508: PL/SQL: could not find program unit being called: "APEX_190100.WWV_FLOW_MAIL" Can You help me out.? and in my toad if i try to compile this APEX_190100.WWV_FLOW_MAIL package i'm getting error as package body is wrapped cannot do anything any solution please?
Dear Vinish i want to create a login page with new user and old user authentication.. for eg if a user has user id and password he can login from login page. but if a user is new to he has to create login credentials.. currenty i have already created custom authentication as shown in your link 'https://www.foxinfotech.in/2019/09/create-custom-authentication-in-5-easy-steps-in-oracle-apex.html' i have also placed a link on login page 'to create new user press here' and redirected the link to another page in application but as i have created autentication i'm not able to redirect to other page from login screen thanks in advance can anyone help me out?