oracle 11g proc for accepting collection throw c# oledb

Question

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..