title: Stored Procedure in Oracle SQL Developer
body: <p>I'm using SQL Oracle to build a stored procedure. I'm trying to build a stored procedure of the SQL-query below</p>
  
  <pre><code>SELECT "Merch"."Id", "Order"."Id", "Order"."OrderExt"
  FROM "Order"
  Join "Merch" ON "Order"."MerchId" = "Merch"."Id"
  WHERE "Merch"."Id" = 25 AND "Order"."OrderExt" = 'TC10045604'
  </code></pre>
  
  <p>I want to use 2 inparameters to compare "Merch.Id" and "Order.OrderExt". Im really new at SQL-Oracle and have a real hard time figuring out how to write this procedure. </p>
  
  <p>One of the problems I have is how do a return a table with "Merch"."Id", "Order"."Id", "Order"."OrderExt" ? </p>
  
  <p>Do I use a cursor in some way?</p>
  
  <p>Can anybody help me out with this problem?</p>