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

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

ryan_oracle_at_cox.net 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: davehau123_at_netscape.net

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: ListGuru_at_fatcity.com (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).