Home » Developer & Programmer » Forms » file open (Forms 6i)
file open [message #598907] Sat, 19 October 2013 05:26 Go to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

I have created an interface in forms 6i which does the following.
1)Open the file location to choose the excel path
2)Open the excel files from that location
3)import the excel file into oracle
now my problem is when i recompiled the forms6i to run on oracle 9iAS, the browse button is not working , is there any other method using java by which i can accomplish this task.

the following code is used for opening the file.


DECLARE
   FILENAME VARCHAR2(256);
BEGIN
	 
	 FILENAME := GET_FILE_NAME(File_Filter=> 'EXCEL Files (*.XLS)|*.XLS|'); 
	 :UPLOAD_FILE_NAME := FILENAME;
END;

Re: file open [message #598914 is a reply to message #598907] Sat, 19 October 2013 15:52 Go to previous messageGo to next message
Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It seems that you might need Webutil to do what you intend to.
Re: file open [message #598917 is a reply to message #598914] Sat, 19 October 2013 16:45 Go to previous messageGo to next message
mughals_king
Messages: 392
Registered: January 2012
Location: pakistan
Senior Member
download this


Regard
mUGHAL
Re: file open [message #598925 is a reply to message #598914] Sat, 19 October 2013 23:27 Go to previous messageGo to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

thanks littlefoot , but the problem is i am not able to find the webutil.pll for forms 6i or 9ias.please suggest me what steps to be taken after downloading.
Re: file open [message #598926 is a reply to message #598917] Sat, 19 October 2013 23:28 Go to previous messageGo to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

thanks mughals , i am basically using get_file_name only which is similar to your syntax but the problem is when i am clicking on the browse button using 9ias , nothing happens.
Re: file open [message #598929 is a reply to message #598926] Sun, 20 October 2013 03:41 Go to previous messageGo to next message
mughals_king
Messages: 392
Registered: January 2012
Location: pakistan
Senior Member
send me your email id i will send you webutil.pll and someother files if you are still facing any problem please let me know, this link will help you.

http://www.orafaq.com/forum/?t=msg&goto=376105&72104/&srch=excel

Regard
Mughal

[Updated on: Sun, 20 October 2013 03:43]

Report message to a moderator

icon13.gif  Re: file open [message #598930 is a reply to message #598929] Sun, 20 October 2013 03:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You cannot send him anything like that, it is Oracle proprietary and you cannot send or sail anything from their products.

@arif_md2009, read this.

Re: file open [message #598931 is a reply to message #598929] Sun, 20 October 2013 04:06 Go to previous message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

thanks
Previous Topic: insert record into lov through oracle custom forms
Next Topic: How to send sms to mobile device using oracle form 6i
Goto Forum:
  


Current Time: Thu Apr 25 22:47:59 CDT 2024