Home » Developer & Programmer » Forms » Writing in Excel
Writing in Excel [message #85861] Thu, 05 August 2004 01:30 Go to next message
S Ramu
Messages: 4
Registered: March 2003
Junior Member
Hi,

 

I have faced a problem while trying to export the result of a query in excel while using forms9i.  Can anyone help to sort out the issue.  Non-oracle error 300600 was thrown while trying with OLE2.  It is expected that 9i release 2 do not support this.

 

Thanks in advance.

 

S Ramu

Report message to a moderator

Re: Writing in Excel [message #85957 is a reply to message #85861] Tue, 17 August 2004 01:35 Go to previous messageGo to next message
shankar
Messages: 29
Registered: January 2002
Junior Member
use text_io to write into a text file. use tab delimited format and save the file with extension .xls

Report message to a moderator

Re: Writing in Excel [message #85958 is a reply to message #85861] Tue, 17 August 2004 02:40 Go to previous message
Himanshu
Messages: 457
Registered: December 2001
Senior Member
Hi,
I doubt that it is not supported in Oracle 9iR2.

Please refer to "Client Side OLE Integration from Oracle 9i Forms - Technical White Paper September 2002" in OTN.

The possible problem in your case may be that Ora OLEDB is installed in another separate ORACLE_HOME from Forms.
When running forms the Ora OLEDB libraries and registry settings are not visible from forms.

So,Install compatible ora oledb into the forms ORACLE_HOME for Forms 9i - it is Ora OLEDB 9.0.1 (required support files).

HTH
Regards
Himanshu

Report message to a moderator

Previous Topic: delete_record
Next Topic: doubt in forms 6i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Aug 07 13:02:36 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.