Welcome to the dBforums forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions, articles and access our other FREE features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload your own photos and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact support.

If you prefer not to see double-underlined words and corresponding ads, place your cursor
here for ContentLink opt out.

Go Back  dBforums > Database Server Software > Oracle > ORA-03113: end-of-file on communication channel

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-15-04, 12:34
Mr_roomi Mr_roomi is offline
Registered User
 
Join Date: Mar 2004
Location: Maryland
Posts: 152
ORA-03113: end-of-file on communication channel

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
__________________
mr_roomi
Reply With Quote
  #2 (permalink)  
Old 06-15-04, 13:42
dbtoo2001 dbtoo2001 is offline
Registered User
 
Join Date: Jan 2004
Location: Scottsdale, AZ
Posts: 106
Post

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
__________________
"Take Control!
Make The Choice!
Accept The Consequences!
Deal With The Results! "
Reply With Quote
  #3 (permalink)  
Old 06-15-04, 14:04
Mr_roomi Mr_roomi is offline
Registered User
 
Join Date: Mar 2004
Location: Maryland
Posts: 152
ORA-03113: end-of-file on communication channel

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.
__________________
mr_roomi
Reply With Quote
  #4 (permalink)  
Old 06-15-04, 14:15
anacedent anacedent is offline
Registered User
 
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 3,566
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
__________________
You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
Reply With Quote
  #5 (permalink)  
Old 06-15-04, 14:33
dbtoo2001 dbtoo2001 is offline
Registered User
 
Join Date: Jan 2004
Location: Scottsdale, AZ
Posts: 106
Talking

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'?)
__________________
"Take Control!
Make The Choice!
Accept The Consequences!
Deal With The Results! "
Reply With Quote
  #6 (permalink)  
Old 06-15-04, 15:02
Mr_roomi Mr_roomi is offline
Registered User
 
Join Date: Mar 2004
Location: Maryland
Posts: 152
Cool funny

dbtoo2001 you are really funny...if you would be in 11 o clock comedy show..you would be Millionaire by now.
__________________
mr_roomi
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On