ORA-28

Hello:

My application team is running the following script:

   INSERT INTO MTHLY_ACTVY_RPT
          ( col1 col2 ... coln )
         SELECT
              :hs_rpt_yr,  (set to 2008 )
              :hiRollbackPrev, (set to -1)
col.. col          FROM
              MTHLY_ACTVY_RPT
         WHERE RPT_YR        = :hs_rpt_yr (2008)
           AND RPT_MTH       = :rpt_mnth ; (05)

Looks like they want to copy all May data into some unexisting month. This
script is running every day and last weekend failed with ora 28  (your
session has been killed). I am not aware of anyone killing this process.
After
that failure they restarted their process and it ran successfully. I don't
see any dump files or anything indicating
any kind of an issue. Can anyone think of a possible reason for this (other
than someone killing the session)
which I could look into?

thank you

Gene Gurevich


--
http://www.freelists.org/webpage/oracle-l

Other related posts: