Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2004
    Location
    Maryland
    Posts
    152

    Unanswered: 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

  2. #2
    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! "

  3. #3
    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

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    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!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    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! "

  6. #6
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •