Writing data from an array of structs to database in Pro*C

From: Raj <bedi.neeraj_at_gmail.com>
Date: 26 Oct 2006 23:34:50 -0700
Message-ID: <1161930890.052936.62890@m73g2000cwd.googlegroups.com>

Hi..
I'm new to Pro*c and cought up in a problem..

I've some data in an array of structs and that array of structs corresponds to a table in the database. Now, i am able to insert data into the table directly with the statement :

EXEC SQL INSERT INTO <tabname> VALUES :name_of_array_of_structs

and the whole array is written to the database, with one struct taking place of a record..

but the problem is that i want to update some of the old records in the table with those in the array of structs and i want the comparison to be based on one of the values in the array. Please tell me a way to acheive the same.. and also the best way to do the same..

Thanks in Advance..
Neeraj Received on Fri Oct 27 2006 - 01:34:50 CDT