Home » Developer & Programmer » Forms » Excel Upload in Forms 12c (Forms 12c 12.2.1.2)
icon8.gif  Excel Upload in Forms 12c [message #668171] Sat, 10 February 2018 22:30 Go to next message
orafaq321
Messages: 8
Registered: February 2018
Junior Member
Hi All,

I am new to Forms 12c, we are upgrding forms 6i to 12c.

In 12c OLE2 is not working to upload excel. Can any please help me...

Thanks in advance...
Re: Excel Upload in Forms 12c [message #668172 is a reply to message #668171] Sat, 10 February 2018 22:57 Go to previous messageGo to next message
BlackSwan
Messages: 26733
Registered: January 2009
Location: SoCal
Senior Member
orafaq321 wrote on Sat, 10 February 2018 20:30
Hi All,

I am new to Forms 12c, we are upgrding forms 6i to 12c.

In 12c OLE2 is not working to upload excel. Can any please help me...

Thanks in advance...
I am sure that "not working" is 100% correct, but it is also 100% devoid of any useful detail to discern what is actually wrong.

We can't see what you do.
We can't see what you see.
We don't know what is wrong.

You have a mystery & we have no clues.

The one fact that I know for sure Oracle does not speak "Excel".
Oracle can produce text data in various formats, CSV, XML, etc., that Excel an import
Re: Excel Upload in Forms 12c [message #668174 is a reply to message #668172] Sun, 11 February 2018 08:04 Go to previous messageGo to next message
orafaq321
Messages: 8
Registered: February 2018
Junior Member
Thanks for the reply BlackSwan...

Let me explain my probelm...

We are upgrading forms 6i to 12c. In 6i version, there is a form which will upload excel(.xls) data into oracle table by using OLE2.

We are able to compile the 6i form in 12c without any compilation error, but OLE2 is not working in 12c version.

Is there any alternative option which can be used in place of OLE2 in 12c?

Please help me...

Thanks in advance.
Re: Excel Upload in Forms 12c [message #668177 is a reply to message #668174] Sun, 11 February 2018 09:40 Go to previous messageGo to next message
BlackSwan
Messages: 26733
Registered: January 2009
Location: SoCal
Senior Member
Why do you think this is an Oracle problem & not a Microsoft problem?

What makes you think that OLE2 is compatible with current Windows version?

Again you state it is "not working"; which is 100% devoid of any useful detail.

My car is not working.
Tell me how to make my car go.
Re: Excel Upload in Forms 12c [message #668178 is a reply to message #668177] Sun, 11 February 2018 09:54 Go to previous messageGo to next message
orafaq321
Messages: 8
Registered: February 2018
Junior Member
Hi...

Not working means, not able to uplaod excel data into oracle table,
at the same time it is not giving any error message.

As per my search in google, OLE2 will not work in Forms 12c.

My requirement is to upload the excel data into oracle table using Forms 12c.

So I need replace existing OLE2 package.

I am not sure whether forms 12c provided any new facility to upload excel into oracle tables.

Please help...
Re: Excel Upload in Forms 12c [message #668181 is a reply to message #668178] Sun, 11 February 2018 12:10 Go to previous messageGo to next message
Littlefoot
Messages: 21592
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't know about Forms 12 (don't have it), but - would Webutil help? Have a look at WebUtil: How to Read an Excel file into an Oracle Form.
Re: Excel Upload in Forms 12c [message #668532 is a reply to message #668181] Wed, 28 February 2018 09:31 Go to previous messageGo to next message
orafaq321
Messages: 8
Registered: February 2018
Junior Member
Thanks for the reply...
I am using the code given in above link. But at this point application is hanging.

application := Client_OLE2.create_obj('Excel.Application');

Installing XL s/w in appliation/DB server is mandatory? or only client system is sufficient?
Re: Excel Upload in Forms 12c [message #668545 is a reply to message #668532] Wed, 28 February 2018 13:22 Go to previous messageGo to next message
joy_division
Messages: 4949
Registered: February 2005
Location: East Coast USA
Senior Member
client_ole sounds to me like webutil is required.
Re: Excel Upload in Forms 12c [message #668547 is a reply to message #668545] Wed, 28 February 2018 21:10 Go to previous messageGo to next message
orafaq321
Messages: 8
Registered: February 2018
Junior Member
webutil already attached. No compilation errors. During program execution it is hanging at this place

application := Client_OLE2.create_obj('Excel.Application');
Re: Excel Upload in Forms 12c [message #668564 is a reply to message #668547] Thu, 01 March 2018 09:38 Go to previous messageGo to next message
orafaq321
Messages: 8
Registered: February 2018
Junior Member
Dear experts ..... pls help me
Re: Excel Upload in Forms 12c [message #668565 is a reply to message #668564] Thu, 01 March 2018 10:27 Go to previous messageGo to next message
BlackSwan
Messages: 26733
Registered: January 2009
Location: SoCal
Senior Member
https://www.thatjeffsmith.com/archive/2012/04/how-to-import-from-excel-to-oracle-with-sql-developer/
Re: Excel Upload in Forms 12c [message #668586 is a reply to message #668565] Sat, 03 March 2018 21:04 Go to previous messageGo to next message
orafaq321
Messages: 8
Registered: February 2018
Junior Member
Thanks for the reply...i need to upload the xl data into oralce tables either using forms 12c or using pl/sql program only.
Re: Excel Upload in Forms 12c [message #668587 is a reply to message #668586] Sat, 03 March 2018 21:31 Go to previous message
BlackSwan
Messages: 26733
Registered: January 2009
Location: SoCal
Senior Member
https://community.oracle.com/message/9362007#9362007
Previous Topic: TNS NAMES ERROR
Next Topic: folder name in oracle forms
Goto Forum:
  


Current Time: Tue Sep 22 15:40:58 CDT 2020