[Mr_roomi]

Hi,

I am trying to get read data from MS Excel file but it is giving me this error:

ORA-03113: end-of-file on communication channel

Code is:

declare
fhandle utl_file.file_type;
fbuffer varchar2(1000);
abc varchar2(100);
def varchar2(100);
begin
fhandle := utl_file.fopen ('f:\khurram\test\', 'book1.xls', 'r');
While true loop
utl_file.get_line (fhandle, fbuffer);
select (substr(fbuffer,1,instr(fbuffer,','))),
to_number(substr(fbuffer,instr(fbuffer,',')+1)) into abc,def
from dual;
dbms_output.put_line(abc||' '||def);
end loop;
end;

Any help will be highly appreicated

[dbtoo2001]

Ask Tom....
Scroll towards the bottom of the attached article, or search it for excel, this is a method to use heterogeneous services to access the spreadsheets.
http://asktom.oracle.com/pls/ask/f?p...:4406709207206

[Mr_roomi]

hi,
I went on that article but that article covers only through ODBC using DSN not from SQL*Plus. I am trying to write a store procedure to get data from Excel spread sheet.

Any help will be appreciated.

Thank you for prompt response.

[anacedent]

from http://asktom.oracle.com using keywords: read excel spreadsheet

why are you seemingly incapable or unwilling to do your own research ?

Hit Subject Last Updated First Asked Age
1. Automate loading of data from Excel spreadsheets into database Score(38) 31 Mar 2004 26 May 2000 4.1 years old
2. Oracle datas into Excell Sheet using pl/sql procedure in Oracle 8i Score(21) 10 May 2004 10 Sep 2000 3.8 years old
3. Yet another ASCII dump issue Score(10) 08 Jan 2004 20 Jul 2000 3.9 years old
4. Data Loading Approach Score(10) 12 Mar 2004 20 Sep 2001 2.7 years old
5. How to achive this Score(8) 03 Jun 2003 06 Jan 2002 2.4 years old
6. Sqlloader and passing passwords from scripts Score(8) 08 Jun 2003 24 May 2002 2.1 years old
7. create a file for excel Score(8) 21 May 2004 02 May 2000 4.1 years old
8. Printing a report to file in .pdf format Score(8) 19 Feb 2004 31 Jan 2001 3.4 years old
9. Storing Chinese Characters Score(8) 29 Sep 2003 06 Jun 2003 1 years old
10. Can UTL_FILE package used to create ASCII files Score(8) 14 May 2004 22 May 2000 4.1 years old
1 - 10 Next

[dbtoo2001]

Hmmm... my guess....?
(A Newbie limerick)

There once was a newbie from St. Lou
who was stumped on a subject, and wouldn't do...
a web search online,
a waste of their time,
they'd just ask a guru who knew.

(or was that 'with ocean view'?)

[Mr_roomi]

dbtoo2001 you are really funny...if you would be in 11 o clock comedy show..you would be Millionaire by now.