|
-
This is the error i am getting:-
PLS-00435: DML statement without BULK In-BIND cannot be used inside FORALL
And my Procedure is as follows:-
DECLARE
v_count NUMBER;
TYPE ARRAY IS TABLE OF sourcing%ROWTYPE;
l_data ARRAY;
p_array_size PLS_INTEGER DEFAULT 5;
CURSOR c IS SELECT * FROM sourcing where rownum<10 ;
BEGIN
OPEN c;
LOOP
FETCH c BULK COLLECT INTO l_data LIMIT p_array_size;
FORALL i IN 1..l_data.COUNT
update sourcing set DISC = trunc(to_date('01/01/1901','MM/DD/YYYY'));
COMMIT;
EXIT WHEN c%NOTFOUND;
END LOOP;
CLOSE c;
Please help me in this regard
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|