title: How to use procedure parameters in merge statement
body: <p>i'm creating a procedure to update/insert a table using merge statement(upsert).now i have a problem: using procedure parameters i have to do this upsert. </p>
  
  <p>procedure xyz( a in table.a%type,b in table.b%type,....)
  is 
  some local variables;
  begin
  merge into target_table
  using source_table --<strong>instead of the source table, i have to use procedure parameters here</strong>
  on (condition on primary key in the table)
  when matched then
  update the table
  when not matched then
  insert the table ;
  end xyz;
  so how to use procedure parameters instead of source table in merge statement?? or
  suggest me a query to fetch the procedure parameters and use it as source table values.</p>
  
  <p>help me please.
  Thanks in advance.</p>