Archive for category Oracle

Bulk insert data in Oracle DB using VB.NET

Sometimes we need to insert n number of records and solution it either to call the procedure in loop and insert the records one at a time or send some delimited strings and split the strings in the database procedure.

One very easy and interesting solution is by using following code:
 

  Here AVal and BVal are string() arrays of size 5.

Njoy:)

, ,

1 Comment