Question about FORALL update

[gayathri Dev]

Hi All,

 

I am using a FORALL bulk update and FORALL bulk Insert statement.

similar to the one used in the below example from the link : http://www.oracle-developer.net/display.php?id=410

 

 

  8     SELECT emp_ot(empno, ename, sal) BULK COLLECT INTO nt_emp
  9     FROM   emp;
10 
11     /* FORALL with workaround... */
12     FORALL i IN 1 .. nt_emp.COUNT
13        UPDATE emp
14        SET    ename = TREAT(nt_emp(i) AS emp_ot).ename
15        ,      sal   = TREAT(nt_emp(i) AS emp_ot).sal * 1.1
16        WHERE  empno = TREAT(nt_emp(i) AS emp_ot).empno;

17     dbms_output.put_line( sql%rowcount);

But the select count from line 8 and 9 was different what is returned from 17th line.

 

How can I get the records those were not inserted or updated.??

 

Thanks in advance

~G

 

[Luciano Pimentel]

I think this link can help you.

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/tuning.htm#i49099

2011/2/3 gayathri Dev <gd0...@gmail.com>

--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle...@googlegroups.com
To unsubscribe from this group, send email to
Oracle-PLSQL...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en