| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: pl/sql table and commit
No you do not need commit when filling pl/sql table variables. If all
data are processed in one session, variable content is visible and
accesible instantly.
I would also suggest using a BULK COLLECT instead of cursor LOOP, it's better technique and also performs faster - example:
OPEN c1;
LOOP
FETCH c1 BULK COLLECT INTO v_DateTable [LIMIT rows];
EXIT WHEN c1%NOTFOUND;
END LOOP;
CLOSE c1;
Ivan Received on Wed Nov 16 2005 - 05:57:25 CST
 |
 |