Open file JavaBean for Web Deployed Forms 6i and WIN_API_DIALOG.OPEN_FILE crashes IE (merged) [message #298234] |
Tue, 05 February 2008 07:22 |
pc131
Messages: 36 Registered: May 2006
|
Member |
|
|
Hi All
I want to use dialog for selecting file in Fomrs 6i.
I attached d2kwutill.pll into form, i uploaded d2kwut60.dll into <ORA_HOME>/bin and coded WIN_API_DIALOG.OPEN_FILE to open file. Everything works fine on the machine I'm developing, the open file dialog works and it returns file name. But when i upload form on remote machine where i access through the web it won't work.
I uploaded d2kwutil.plx on remote machine to the directory where forms reside. This is when I attach library without storing full path of it which is in my case c:\someFormsDir - note! on remote machine Forms reside on d:\Forms, and on local machine I have only c: HDD D: is cdrom and i can't change drive letters.
I also try to upload d2kwutil.plx in c:\someFomrsDir on remote machine although forms there reside in d:\Forms, but on local machine library(and forms) reside in c:\someFormsDir.
None of two above examples work.
I upload d2kwut60.dll in <ORACLE_HOME>\bin direcotry - doesn't work. I even upload d2kwut60.dll in orahome2\bin direcory, doesn't work. On my local machine d2kwut60.dll is in ORA_HOME\bin where ifsrv60.exe can be found, the same i do on remote.
When I puch button to open dialog for choosing file Internet Explorer freezes.
Any help from experts?
Thanks
Tom
|
|
|
|
|
|
Re: WIN_API_DIALOG.OPEN_FILE crashes IE [message #298278 is a reply to message #298234] |
Tue, 05 February 2008 09:31 |
pc131
Messages: 36 Registered: May 2006
|
Member |
|
|
Seems like GET_FILE_NAME won't work on remote web deployed application.
This is code:
declare
file1 text_io.file_type;
filename1 varchar(256);
linebuf varchar2(100);
begin
filename1 := GET_FILE_NAME('%HOMEPATH%',File_Filter=> 'TXT Files (*.txt)|*.txt|');
file1 := TEXT_IO.FOPEN(filename1, 'r');
Text_IO.Get_Line(file1, linebuf);
if linebuf!='blablablablabla' then msg('line is OK!');
else msg('Line is wrong!');
end if;
TEXT_IO.FCLOSE(file1);
end;
But on web deployed app this code DOESN'T work. Any ideas, why?
Tom
======================
GET_FILE_NAME not supported on web deployed applications. Topic closed.
[Updated on: Tue, 05 February 2008 09:41] Report message to a moderator
|
|
|
|
|
|
Re: Open file JavaBean for Web Deployed Forms 6i and WIN_API_DIALOG.OPEN_FILE crashes IE (merged) [message #298484 is a reply to message #298234] |
Wed, 06 February 2008 03:52 |
pc131
Messages: 36 Registered: May 2006
|
Member |
|
|
Hi
Thanks for interest
Here is about d2kwutil.pll not working on Web -> HERE. I believe i saw the same in Oracle html readme to d2kwutil.pll library. It says: " Many of the functions in the library require access to Window Handles, which will not work on the Web".
About built-in GET_FILE_NAME i read on oracle forums -> HERE.
I studied http://www.oracle.com/technology/sample_code/products/forms/6idemos.html but it looks like it is for uploading(transferring) file physically onto middle-tier. I do not need neither want that. I need only to get the path to file using such "Open File Dialog" - which works fine for me either using GET_FILE_NAME and WIN_API_DIALOG.FILE_NAME but again as I stated before none of these 2 methods seem to work on deployed applications.
Seems like I'm stuck to entering path to file that has to be processed manually.....
I already managed to create disk D: and the same directory structure as on web deployed app. And I attach d2kwutil.pll library with or without saving full library path. Nothing changes. The form freezes. When I use GET_FILE_NAME nothing happens on web.
I added (since modules in thies app are called directly with full path, not registry set values) FORMS60_PATH, D2KTUIL_PATH (D2KWUTIL60_PATH in any case) to the registry, nothing helped.
Am I stuck to point file manualy in this case?
Regards
Tom
|
|
|
Re: Open file JavaBean for Web Deployed Forms 6i and WIN_API_DIALOG.OPEN_FILE crashes IE (merged) [message #298559 is a reply to message #298484] |
Wed, 06 February 2008 06:46 |
pc131
Messages: 36 Registered: May 2006
|
Member |
|
|
HI!!!!
I have coded parsing file by using TEXT_IO.GET_LINE but it seems that my remote file even can't be opened on remote server.
declare
file1 text_io.file_type;
filename1 varchar(256);
linebuf varchar2(100);
begin
file1 := TEXT_IO.FOPEN('C:\documents and settings\<my_home_dir>\details.txt', 'r');
Text_IO.Get_Line(file1, linebuf);
if linebuf!='blablablablabla' then msg('line is OK!');
else msg('Line is wrong!');
end if;
TEXT_IO.FCLOSE(file1);
end;
On local machine when i run form and enter "C:\details.txt" the file gets loaded because it gets processing, I can see messages.
When I upload form onto remote web-deployed app server, I enter into path "C:\documents and settings\<my_home_dir>:\details.txt" (I cannot write on C: directly, the files are the same, file C:\documents and settings\<my_home_dir>details.txt has all permisions to everyone) nothing happens. Does it mean text_io won't work on Fomrs6i web-deployed? How can I investigate this issue.
Thanks in advance
Tomek
|
|
|
|
|
Re: Open file JavaBean for Web Deployed Forms 6i and WIN_API_DIALOG.OPEN_FILE crashes IE (merged) [message #486815 is a reply to message #298732] |
Mon, 20 December 2010 07:16 |
|
usman_ghani96
Messages: 4 Registered: December 2010
|
Junior Member |
|
|
Hi Tom
I have a same problem can u tell me how can u fix this problem i m using form 6i and using built in text_io procedure to read file from client side and insert data into table i set a trigger on button and give a reference of procedure in when-button-pressed trigger i have no compilation error but when i deploy my form on a remote web-deployed app server it give error "FRM-40735 WHEN-BUTTON-PRESSED TRIGGER RAISED UNHANDLED EXCEPTION ORA-302000" i will be very thanks full to you providing a solution.
Usman
|
|
|