title: How to pass comma-separated values passed as string parameter to an Oracle stored procedure?
body: <p>I am trying to write a stored procedure in Oracle in which I am passing string value in <code>myString</code> whose value is like (<code>'xxx','yyy'</code>) as <code>varchar</code> and returning a cursor. My procedure looks like as below:</p>
  
  <pre><code>create or replace getName (in_myString in varchar, Name_list out refcursor) IS
  Begin
      Open cursor for 
         Select Colunm1 from table where columnName in (in_MyString);
  </code></pre>
  
  <p>But is not returning any records but I am trying to run the query alone it is returning the records. Please can anyone help me?</p>