SQL & PL/SQL

All,

I am trying to do bulk insert using dynamic sql, since these tables exist in different schema.

create or replace procedure bulk_insert

    premiumRate_rec_tab  T_PREMIUM_RATE := new T_PREMIUM_RATE();

  sql_str          VARCHAR2 (4000);

begin

    sql_str := 'select col1,col2

                   from tab a. tab b

                  ......

                 ;

          BULK COLLECT INTO premiumRate_rec_tab;

    FORALL idx1 IN 1..premiumRate_rec_tab.count

      EXECUTE IMMEDIATE 'INSERT INTO ' ||.........

               values (:1,:2,:3....)'

            using  premiumRate_rec_tab(idx).col1, premiumRate_rec_tab(idx).col2

      ;

end;

when I compile the above proc it is giving me the following error:

PLS-00801: internal error [*** ASSERT at file pdw4.c, line 3572; Can't handle Object

Any help would be appreciated

Kindest Regards,

Naga