Hi I want to get client desktop name in oracle apex . I am unable to find solution
rehanContributor
hi what I am trying to achieve is on WHEN-MOUSE-DOUBLECLICK on a column field, opens an editor fetching a few columns from tables, which will return single/multiple rows. on running the following piece of code, i am only getting 1 row displayed inside the EDITOR for a multi-row dataset. DECLARE CURSOR C_TXT1 IS SELECT mprdh_no|| chr(9) ||ACNT_NAME|| chr(9) ||to_char(mprd_amount,'999999,990') FROM MPR_FORMD,ACCOUNTS_MASTER WHERE ACNT_CODE = MPRD_ITEM_CODE AND MPRDH_NO = 384; VAL VARCHAR2(4000); ed_ok BOOLEAN; BEGIN OPEN C_TXT1; FETCH C_TXT1 INTO VAL; CLOSE C_TXT1; Show_Editor( 'REMARKS_EDIT', val, 250,150, val, ed_ok); END; the below query resutl is expected as seen from running at the sql prompt; SQL> SELECT mprdh_no|| chr(9) ||ACNT_NAME|| chr(9) ||to_char(mprd_amount,'999999,990') 2 FROM MPR_FORMD,ACCOUNTS_MASTER 3 WHERE ACNT_CODE = MPRD_ITEM_CODE 4 AND MPRDH_NO = 384; MPRDH_NO||CHR(9)||ACNT_NAME||CHR(9)||TO_CHAR(MPRD_AMOUNT,'999999,990') ---------------------------------------------------------------------------------------------------- 384 R&M DOOR ACCESS CONTROL SYSTEM 143 384 R&M DOOR ACCESS CONTROL SYSTEM 143 384 ...
BheemProfessional
Hi I need amount to display Right corner of screen for each transactions. Please help.
Hi! I have a large HTML stored in a table, and I can't display that records with items, because they have a limit of 32k. So it works with PL/SQL Dynamic Region when is printed in chunks. The problem is that HTML is not displayed as HTML than as text, so instead of formated text, I am getting HTML tags.
Hi Sir jii, Need to add the sum of column total at run time in IG report when in click add row button. Can you Please suggest.
KndprasadContributor
Hi, I am working on the breadcrumb. I have problem to display the breadcrumb on multiple parents and child. Example. 1 .parent pages 1 -> 2 ->3 child 7 2.Parent Pages 4 -> 5 ->6 child 7. In above example finally both parents are accessing child 7. Thanks prasad
Hi sir jii, How to pass column name as parameter when i navigate from page to page can you please suggest.
khaled sawaftehContributor
Dear, In oracle forms 10g there is a host command to call operating system like (call jar file) so i need to call JAR file by APEX 21.1 TKS
Hi, I am new to apex and need help please. How do i create a database directory to call file in apex. Thanks Freelee207
swamy kumarContributor
HI, how to download a zip file which is stored in directory with the button click in oracle apex I had written a process to call it but throwing the error as syntaxError: Unexpected token 'P', "PK"... is not valid JSON.. Here is my piece of code written in processing: declare Lob_loc bfile; begin Lob_loc := bfilename('ABC_DIRECTORY','data file.zip'); OWA_UTIL.MIME_HEADER( 'application/zip', FALSE ); htp.p('Content-Disposition: attachment; filename="'||'data file.zip"'); owa_util.http_header_close; wpg_docload.download_file(Lob_loc); apex_application.stop_apex_engine; exception when others then raise_application_error(-20002, SQLCODE||' — '||SQLERRM); apex_application.stop_apex_engine; end;