Using host arrays in PLSQL

Hi,

Is there any way I can use arrays or host arrays to INSERT/UPDATE/DELETE

for example 100 rows in one operation in PL/SQL (as you can do it in Pro C)

Something like:

DECLARE
    names[100];
BEGIN

• Insert 100 rows in one operation names[0] := 'Superman'; names[1] := 'Batman'; INSERT INTO name_table VALUES (names);
• Fetch 100 rows in one operation SELECT name FROM name_table INTO names

END; Regards,

Flemming Jans
(fj_at_belle.dk) Received on Wed Sep 23 1998 - 00:00:00 CDT