CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

Home: Perl Programming Help: Beginner:
Bind 2D array to Oracle SQL

 



sinpeak
New User

Jan 10, 2011, 6:31 AM

Post #1 of 1 (207 views)
Bind 2D array to Oracle SQL Can't Post

Hi,

I am in the need of doing a bulk insert via :

SQL - INSERT INTO <table> (SELECT..)

OR

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.

Thanks.

 
 


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives