Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Location
    Karachi, Pakistan
    Posts
    45

    Unanswered: System terminate session while applying nested round

    Hi,

    While I apply nested round on my selection

    Select
    round((aa.energy/round(aa.averagedaily,3)),3)
    From (
    SELECT
    a.newreadingid UIDMTRDATAREAD
    ,e.spmtrhistid UIDMTRDATACHANNEL
    ,4 UIDUSAGECATEGORY
    .........

    like this, System will terminate my session by error # ORA-03113.

    if I am using this

    Select
    (aa.energy/round(aa.averagedaily,3))
    From (
    SELECT
    a.newreadingid UIDMTRDATAREAD
    ,e.spmtrhistid UIDMTRDATACHANNEL
    ,4 UIDUSAGECATEGORY
    .........

    it works perfectly fine.

    does any one idea why it could happened?

    I am stuck on this issue kindly let me know if any have any idea about it.

  2. #2
    Join Date
    Feb 2006
    Posts
    173
    Provided Answers: 1
    Check this link out: ORA-03113: end-of-file on communication channel

    What other oracle messages are logged?

Posting Permissions

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