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?
Hi! I am trying to redirect page using DA and PL/SQL and set items value. Friendly URLs is switch to on. Thanks in advance!
I have created application item and application Computation in shared component and refrenced it in desktop navigation menu but the thing is i want to change the colour of application item which i have refrenced ..
Hi, I am using mail_client api to read emails from outlook server which is working fine. But i need to sync new emails once they come to inbox immediately. Current load email procedure loads all the emails from inbox which will take tooo much time.
I created a login page and it has a captcha. Now I want to show captcha when user enter wrong username or password. For that I want to add a page item as a counter that has default value = 0, when user enter wrong username or password, counter becomes counter + 1 and when counter >= 1 then login page shows captcha. So what should I do for that? I have another question: Is it possible that some processes don't execute when a page item's type is hidden?
Welcome to the community.