Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FORALL and IF condition

ChaitanyaGoparajuNov 9 2010 — edited Nov 10 2010
Hi All,

i am using a forall to insert data into a table..
however when i do the insert, i need to check if one column is not null...

but when i am trying to do it , i am getting an exception saying that dml should follow FORALL.

is there any way to do this?? for instance,

forall c in type_emp.first..type_emp.last
if (COndition satisfied) then
insert into table
end if;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 8 2010
Added on Nov 9 2010
15 comments
3,180 views