Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can a stored procedure receive a VB array

Status
Not open for further replies.
IQ

IQ

Programmer
Mar 15, 2000
20
GB
I have a scenario where I need to insert approx. 2000 records into an Oracle 8i database from a VB6 application.

The simplest way is to call a stored procedure which inserts a single record 2000 times but performance will not be very good and will kill my network.

Is there any way in which I can pass an array of 2000 records to a stored procedure that could then loop internally to insert all of the records.

Any help would be gratefully received.

Thanks

IQ
 
Status
Not open for further replies.

Similar threads

Chopstik
  • Locked
  • Question
How to identify a package based on a code snippet 1
Replies
1
Views
323
Andrzejek
Andrzejek
Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
376
Andrzejek
Andrzejek
Andrzejek
  • Locked
  • Question
Format a number - TO_CHAR() 2
Replies
5
Views
407
SkipVought
S
Livia8
  • Locked
  • Question
Can deleted files/ directories (rm -r) be retrieved again?
Replies
6
Views
230
Livia8
Livia8
George L
  • Locked
  • Question
web app not saving "all" records suddenly
Replies
3
Views
359
carp
carp

Part and Inventory Search

Sponsor

Back
Top