Jan 10, 2011, 6:31 AM
Post #1 of 1
Bind 2D array to Oracle SQL
I am in the need of doing a bulk insert via :
SQL - INSERT INTO <table> (SELECT..)
PLSQL Block - FORALL i IN 1 .. count INSERT INTO <table>(arrayname(i))
I have a 2D array in my perl code which has the rows to be bulk inserted.
Is there a way to bind the 2D array to the SQL or the PLSQL block ???
I tried execute_array() but it seems it can be used for a 1D array and not for a 2D one.