title: Procedure conversion in Oracle
body: <p>I am a new member here so apologies from me if i am not able to follow the rules here.
  I am using Oracle 11g express edition along with pl/sql. I am trying to convert a database of sql server in oracle 11g. So far i have done everything.
  But now i am trying to convert <code>procedures</code>. I have done all changing but still i am not able to make procedures completely. </p>
  
  <p>This is code of procedure in SQL server:</p>
  
  <pre><code>create proc Result_proc 
  @name varchar(40),
  @Test varchar(40)
  as
  (
  select * from [Result View] where ([Student Name] = @name AND Test# IN (@Test)) 
  )
  </code></pre>
  
  <p>Converted code in ORACLE:</p>
  
  <pre><code>create or replace procedure Result_proc ( 
  p_name varchar2,
  p_Test varchar2)
  as
  begin
  (
  select * from ahmad where (Student_Name = p_name AND Test# IN (p_Test)) 
  )
  end;
  </code></pre>
  
  <p>Here in the image you see when i run the converted code in PL/SQL it is not executed properly:<a href="https://i.stack.imgur.com/smfuB.png" rel="nofollow noreferrer">Output of CONVERTED proc in PL/SQL</a></p>
  
  <p>Output:</p>
  
  <pre><code>SQL&gt; 10
  </code></pre>