title: Example for stored procedure with output variables
body: <p>I have gone through lot of tutorials on the web on how to create a stored procedure. I understand that to use a procedure, syntax is &quot;Call procedure_name(in parameters)&quot;. But i have found no appreciable example for stored procedure which have multiple output parameters. Could you please give me an example of procedure with out parameters and how to use(call/handle the out parameters) that? Can the output parameters be a table/view type?</p>
  <p>Help would be greatly appreciated.</p>
  <p>Thanks in advance</p>
  <p>-Adithya</p>