PL/SQL (MOSC)

MOSC Banner

errors with save exceptions and forall

edited Jun 9, 2011 3:04AM in PL/SQL (MOSC) 14 commentsAnswered
 Hi,
I have a table that contains duplicates keys. I insert the data in this table in another table that already contains data.
I use FORALL with SAVE EXCEPTIONS.
I do not get any errors of duplicates keys with sql%bulk_exception.

Oracle version is 10.2.0.1

Is this a known bug in this version, and what version is it fixed?

    begin
      forall i in 1..VI_DOS_NUMID.count() save exceptions
        insert into IMP_CPT
          (
            DOS_NUMID,
            TCP_NUM,
            ECP_NUM,
            UNT_NUM,
            PTF_NUM,
            CPP_SOLDE,
            CPP_DATE_LV,
            CPP_DATE_MODIF,
            CPP_CUMUL_CREDIT,
            CPP_DATE_CREA
          )
          values
          (
            VI_DOS_NUMID(i),

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center