Forum Stats

  • 3,852,824 Users
  • 2,264,140 Discussions
  • 7,905,154 Comments

Discussions

browse window closes automatically when file is opened

Ateeq
Ateeq Member Posts: 19 Green Ribbon
edited Sep 20, 2022 6:17AM in Forms

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;