VARRAYs - TechRepublic
General discussion
September 25, 2001 at 03:37 AM
arvind.narasimhan

VARRAYs

by arvind.narasimhan . Updated 21 years, 1 month ago

Hi,
1. Does the use of VARRAYs pose any known performance bottleneck? We are developing a system where we pass data to an Oracle stored procedure (Oracle 8.1.7) from the middle layer (Weblogic 5.1) in a multi-tier system and carrying out INSERTs into multiple tables in a loop.

2. When connecting to the DB, we make use of oracle’s thin driver. I was told that the use of OCI to connect to the DB would enhance performance. Is that true?

Thanks in advance

This discussion is locked

All Comments