Home » SQL & PL/SQL » SQL & PL/SQL » How to print my input in excel through pl/sql procedure
How to print my input in excel through pl/sql procedure [message #232811] Mon, 23 April 2007 06:45 Go to next message
chandrasekharbomminisidda
Messages: 21
Registered: March 2007
Location: Chennai
Junior Member
Respected Sir,

If i want to print my input in excel sheet which i took as a input parameter for my procedure
for example my procedure:

create or replace procedure create_csv('hello this is wonder world').

I want to print hello this is wonder world in excel sheet.

How can i acheive this through pl/sql procedure. with out utl_file predefined package.

Please help me regarding this.

Sincerely,
Chandrasekhar B.S.
Re: How to print my input in excel through pl/sql procedure [message #232814 is a reply to message #232811] Mon, 23 April 2007 06:54 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Hi user570124,

XLS (MS Excel file format is a proprietary Microsoft format). The alternatives are:
1. OWA_SYLK (search for it here or on OTN)
2. A CSV (comma separated file)
3. Heterogeneous Services (ODBC database link to Excel

MHE
Previous Topic: Catch a TABLE NAME
Next Topic: Group by - date
Goto Forum:
  


Current Time: Mon Dec 05 21:17:47 CST 2016

Total time taken to generate the page: 0.05440 seconds