Home » Developer & Programmer » Precompilers, OCI & OCCI » Proc Example required for bulk updates
Proc Example required for bulk updates [message #165410] Wed, 29 March 2006 22:58
hrishy
Messages: 25
Registered: August 2005
Junior Member
Hi

I need to update a table based on another table where both the tables have milliosn of records.

I need to do that in Proc using bulk updates say in array of 5000 records.Does anybody have a sample code to do this.

I cannot do this in straight sql beacsue the record volume is really huge i need to intermediate commits.

So far
i have used a host struct to the record format and a pointer to that structure but i am confused on how to increment the pointer when using bulk updates anybody ahs examples

regards
Hrishy

Previous Topic: OCIReset always fails and query still executing
Next Topic: pro*cobol
Goto Forum:
  


Current Time: Fri Mar 29 10:48:28 CDT 2024