Re: passing an array variable from a .Net middle tier to a databse

[Dave Hau]

According to what you said, the OO guys already pass an array to the 
database.  In this case, they most likely are already using array 
binding.  With array binding, you don't need to define the variable to 
be a pl/sql table on the DB side.  All you need to make sure is you use 
bind variables which is most definitely the case since I don't know how 
else you would pass an array to the database.  If that's the case, then 
you're already doing array insert which is equivalent to bulk insert on 
pl/sql.  Bulk insert on pl/sql calls the same array insert OCI interface 
 behind the scene.  The only difference is it's called from within the 
process, since the pl/sql interpreter runs in-process with the database. 
 But speed wise, it doesn't make a big difference.

- Dave





[EMAIL PROTECTED] wrote:
Im sure on the DB side this is the same for Java and C/C++ also. 

The OO guys pass us an array. When I write my code, I need to define a PL/SQL table that maps exactly to the array correct? 

Our middle tier is having problem doing bulk inserts since its doing one at a time and I believe it closes the session each time. I also think there is an auto-commit on. 

I cant help with that... However, I want to pass it to a pl/sql table with some other variables then dynamically insert it into the database from package. This should clear up the bottleneck. 

is this doable? I cannot touch the middle tier or OO stuff. Strictly the database. 



--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Dave Hau
 INET: [EMAIL PROTECTED]
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).