SQL PLUS Question

From: Arthur Merar <amerar_at_unsu.com>
Date: Sat, 13 Mar 1999 23:58:11 GMT
Message-ID: <36ebfae8.861795@news.chaven.com>

Hello,

I have a simple query that I wrote. It pulls records from one table and inserts them into another. I needed to name each field because the fields are not in the same order in each table.

Anyhow, the query runs for about 30 seconds then I get the following error:

ORA-03113 End of file on communications channel

What is this? I get knocked out of SQL PLUS. Here is a copy of the insert statement.

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);

Thanks,

Arthur
amerar_at_unsu.com Received on Sat Mar 13 1999 - 17:58:11 CST