title: Check using stored procedure is better or select command in asp.net
body: <p>I am re-engineering an Oracle form to asp.net page.</p>
  
  <p>My question is that is there any difference if I use a stored procedure and run a cursor or by using a <code>OracleAdapter</code> fetch data with select command?</p>
  
  <p>Solution 1:</p>
  
  <pre><code>call a cursor in backend (stored procedure)
  </code></pre>
  
  <p>Solution 2:</p>
  
  <pre><code>write select command
  
  OracleAdaptor oap = new OracleAdaptor();
  oap.selectCommand = new OracleCommand();
  oap.SelectCommand.CommandText = "Select v_name from table1 where v_name="+textbox1.text;
  oap.SelectCommand.CommandType = CommandType.Text;
  </code></pre>
  
  <p>Well in my point of view both are select command, would you help me? I want to chose one of them.</p>
  
  <p>Which one is <em>faster</em> and <em>more recommended?</em></p>
  
  <p>My Oracle database is 9i.</p>