I need to update oracle 11g db tables like
G_X_Table => groupid(fk),itemid(fk)
Group_Table => groupid(PK),groupName
Item_Table => itemid(PK),itemName
I need to write a stored procedure while updating(insert,delete).I have to pass one groupId and ItemId collection to procedure where insert G_X_Table with groupid and collection,those are not there in item collection those need to delete. Please help me to write procedure.
I need to call this Procedure through C# with oledb connection please anybody help me. I am very new with oracle..connection through c#.
my idea: delete form G_X_Table where groupid=input groupid and insert G_X_Table with new values. But I am confused what the type i need to accept item collection in procedure and what oledb type i need to pass as input parameter.
Thanks in advance..