OraFAQ Forum: Precompilers, OCI & OCCI » Proc Example required for bulk updates

Home » Developer & Programmer » Precompilers, OCI & OCCI » Proc Example required for bulk updates

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 08:30:38 CST 2025