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..
Discy Latest Questions
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?
I am having form and interactive grid on same page in my apex application like header and detail part if i do change in Header and Detail both and press apply change buttton it shows me following error: No Primary Key item has been defined for form region INV_HDR. if i do change in only header part and perss apply change button changes get saved .
I have a report in my apex app in which in report i have kept page items as parameters through which report gets displayed In which there are page items 1) id 2) image i'm trying to display image based on page item id , my image column gets image through "blob column return by sql statement" i'm not getting Image based on id i tried all dynamic action like refresh page item image when id is changed can any one help me out?