Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

browse window closes automatically when file is opened

AteeqSep 20 2022 — edited Sep 20 2022

Hi experts,
I am using oracle forms 6i and Database (11.2.0.4).
I wrote a code in button pressed trigger to invoke a browse window. When the browse window is opened, the user selects the file (e.g. PDF) and double click it to read. Once the PDF opens, the browser window automatically closes.
Is there a way to keep the browse window open unless the user closes it.
The code is as below:
DECLARE
FNAME VARCHAR2(200);
BEGIN
FNAME:=GET_FILE_NAME('\\172.17.67.16\scan_folder\'||:BLK_GRN_MASTER.PO_NUMBER,NULL,NULL,'All files (*.*)',OPEN_FILE,TRUE);
if FNAME is not null then
host ('rundll32.exe url.dll,FileProtocolHandler '||FNAME);
end if;
END;

Post Details

Added on Sep 20 2022
0 comments
137 views