Hi sir jii,i have the scenario where when i click add row button in IG report all the existing rows should be cleared and only one row need to created by default . Can u please suggest.
Discy Latest Questions
I am creating a collection in page1 and saving the collection name into a page item . Now I have to pass this collection to page 3 and use there. I used the page item where I stored the collection name as a parameter to page 3 and trying to use in page3 , but somehow it does not work. can you give some guidance Thanks George Thomas
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..
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?