ORA-03113 error

From: Arthur Merar <amerar_at_unsu.com>
Date: Mon, 15 Mar 1999 12:14:50 GMT
Message-ID: <36ecf9b0.25371213@news.chaven.com>

Hello,

I run the following insert statement and get an error. Oracle runs the insert for about 30 seconds then gives me the following:

ORA-03113 End of file on communications channel.

What does this mean and why is it happeneing? This is a simple insert statement......I am taking fields from one table and inserting them into another table........

All parens are balanced and stuff.....so I do not get it. Any help is appreciated.

Thanks,

Arthur
amerar_at_unsu.com

insert into cash_man.ej1_art (TRANDATETIME, SEQNUM,
USERID,
WSID,
OFFICENAME,
EFFCTVDATE,
CATEGORY,
RECEIVEDDATE,

TRANNAME,
TRANTYPE,
VOIDSTAT,
CORRSTAT,
XMITSTAT,

SUSPENDED,
SUPERVID,
BATCHNUM,
TRANNUM,

CORRDTRANNUM,
CORRNTRANNUM,
CONTDTRANNUM,
CONTNTRANNUM,

TRANAMT,
ACCTNUM,
TRANCODE,
TABNUM,
HOSTRSPMSG,
OTHERDATA,

MISC1,
MISC2,
MISC3,
MISC4,
MISC5,
MISC6,
MISC7,
MISC8,
MISC9,
MISC10,

MISC11,
MISC12,

ACCOUNTKEY1,
ACCOUNTKEY2,
ACCOUNTKEY3,
ACCOUNTKEY4,
ACCOUNTKEY5,

CITYID,
TRANAMT_N,

DATE_TIME_BATCH_CLOSED,
TRAN_AMT_CASH1,
TRAN_AMT_CHECK1,
TRAN_AMT_CREDIT1,
TRAN_AMT_CASH2,
TRAN_AMT_CHECK2,
TRAN_AMT_CREDIT2,
MISC13,
MISC14,
MISC15,
MISC16,
MISC17,
MISC18,
MISC19,
MISC20,
MISC21,

MISC22,
MISC23,

TRAN_AMT_CASH3,
TRAN_AMT_CHECK3,
TRAN_AMT_CREDIT3,
TRAN_AMT_CREDIT1EL,
TRAN_AMT_CREDIT2EL,
TRAN_AMT_CREDIT3EL,
TRAN_AMT_CREDIT1LC,
TRAN_AMT_CREDIT2LC,
TRAN_AMT_CREDIT3LC,
TRAN_AMT_CREDIT1AC,
TRAN_AMT_CREDIT2AC,
TRAN_AMT_CREDIT3AC,
TRAN_AMT_CREDIT1FS,
TRAN_AMT_CREDIT2FS,
TRAN_AMT_CREDIT3FS,
TRAN_AMT_CREDIT1OT,
TRAN_AMT_CREDIT2OT,
TRAN_AMT_CREDIT3OT)

  select (TRANDATETIME,
  SEQNUM,
  USERID,
  WSID,
  OFFICENAME,
  EFFCTVDATE,
  CATEGORY,
  RECEIVEDDATE,

  TRANNAME,
  TRANTYPE,
  VOIDSTAT,
  CORRSTAT,
  XMITSTAT,

  SUSPENDED,
  SUPERVID,
  BATCHNUM,
  TRANNUM,

  CORRDTRANNUM,
  CORRNTRANNUM,
  CONTDTRANNUM,
  CONTNTRANNUM,

  TRANAMT,
  ACCTNUM,
  TRANCODE,
  TABNUM,
  HOSTRSPMSG,
  OTHERDATA,

  MISC1,
  MISC2,
  MISC3,
  MISC4,
  MISC5,
  MISC6,
  MISC7,
  MISC8,
  MISC9,
  MISC10,

  MISC11,
  MISC12,

  ACCOUNTKEY1,
  ACCOUNTKEY2,
  ACCOUNTKEY3,
  ACCOUNTKEY4,
  ACCOUNTKEY5,

  CITYID,
  TRANAMT_N,

  DATE_TIME_BATCH_CLOSED,
  TRAN_AMT_CASH1,
  TRAN_AMT_CHECK1,
  TRAN_AMT_CREDIT1,
  TRAN_AMT_CASH2,
  TRAN_AMT_CHECK2,
  TRAN_AMT_CREDIT2,
  MISC13,
  MISC14,
  MISC15,
  MISC16,
  MISC17,
  MISC18,
  MISC19,
  MISC20,
  MISC21,

  MISC22,
  MISC23,

  TRAN_AMT_CASH3,
  TRAN_AMT_CHECK3,
  TRAN_AMT_CREDIT3,
  TRAN_AMT_CREDIT1EL,
  TRAN_AMT_CREDIT2EL,
  TRAN_AMT_CREDIT3EL,
  TRAN_AMT_CREDIT1LC,
  TRAN_AMT_CREDIT2LC,
  TRAN_AMT_CREDIT3LC,
  TRAN_AMT_CREDIT1AC,
  TRAN_AMT_CREDIT2AC,
  TRAN_AMT_CREDIT3AC,
  TRAN_AMT_CREDIT1FS,
  TRAN_AMT_CREDIT2FS,
  TRAN_AMT_CREDIT3FS,
  TRAN_AMT_CREDIT1OT,
  TRAN_AMT_CREDIT2OT,
  TRAN_AMT_CREDIT3OT

  from cash_man.ej1); Received on Mon Mar 15 1999 - 06:14:50 CST