Hi flocks..
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 from the collection what r 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. A am confused what the type i need to accept item collection in procedure and what oledb type i need to pass as parameter.
Thanks in advance..