❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
OrclQA.Com is a question and answer forum for programmers.
Here anyone can ask questions and anyone can answer to help others.
It hardly takes a minute to sign up and it is 100% FREE.
Showing Return value in Interactive grid column
Farooq Ahmad
Hi See You Have PO_detail Table and GRN_DETAIL now you will have PO_NO in GRN_Detail so use not in query in where clause and get by pl sql curser
Rate doesn't take from database when query/Item selection
Farooq Ahmad
your question is not explain well but what i get is. you need create DA on item_code and set value then sql query select rate from item where item_code=:P2_ITEM_CODE item to submit and effected item rate you will get what you want if this not your requirement please explain
Run Oracle RDF Report from Oracle Apex 20.1
Farooq Ahmad
The best Way To Call RDF Install Application Server Then In cgicmd file create keyname of user credentials .then create substitutions like REP_URL and value http://localhost:7778/reports/rwservlet?keyname&destype=cache&desformat=pdf now go page from where you want call javascript:window.openRead more
Dynamic Action Redirect To Another Page in Oracle Apex
Farooq Ahmad
Dear Sir Page 3 is Modal dialog page and there is one page item name :P3_CODE in i want pass from Page 2 this &REP_URL.&REPORT=&REP_DIR.Invoice.rep&PRM_CODE=&GLB_CODE.&PRM_NUM=&P2_CODE. this all will go to p3 page item not in URL
How to Open any Window Program (Paint/Calculator)
Farooq Ahmad
Calculator button DA executes JavaScript. window.open('Calculator:///'); save and run click btn it will open in a new tab; click on open calculator paint never try, but I must say you try on it
Developer Suite with windows server 2019
Farooq Ahmad
If you are getting fail as you run the setup, then first set virtual memory. Then restart your machine and use compatibility mode, and it will pass.
Inline Dialog Refresh before opening
Farooq Ahmad
Thanks sir, great now, my requirements change a little. I have three-page items and one global parameter, and this all combines I pass into one another page item (: P2_QRY) and from that :P2_QRY the inline dialogue will run .... as I changing the parameter of page items :P2_QRY is not updating, andRead more
Developer Suite with windows server 2019
Farooq Ahmad
i did it on 2016 and its working what error coming to you
Display Image in Interactive Grid Report Apex 20.1
Farooq Ahmad
select "ID","NAME",sys.dbms_lob.getlength("PIC")"PIC","MIMETYPE","FILENAME", decode(nvl(dbms_lob.getlength(PIC),0),0,null, '<img alt="'||apex_escape.html_attribute(NAME)||'" title="'||apex_escape.html_attribute(NAME) ||'" style="border: 4px solid #CCC; -moz-border-radius: 4px; -webkit-border-radiRead more
Display Image in Interactive Grid Report Apex 20.1
Farooq Ahmad
hi your blob column will store on db or it will come from path