SQL Question

From: Arthur Merar <amerar_at_unsu.com>
Date: Sun, 14 Mar 1999 22:40:27 GMT
Message-ID: <36ec3a5e.1882007@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 Sun Mar 14 1999 - 16:40:27 CST