i have a select query which returns a resultset/recordset with a number of records.
I want to pass this recordset as a parameter to a stored procedure to see if the record exists in the other table, it will just update the particular record else will insert it into the table.

Can anybody help me out. I am new to oracle so dont know how to do it.