how to pass string with quotation marks to a oracle procedure
<p>i have a variable that receive the string like this:</p>

<p><code>'BA','RJ','SC'</code></p>

<p>and i need to send to db in this format as a string, but i'm getting the error:</p>

<blockquote>
  <p><strong>PLS-00103:</strong> Encountered the symbol "BA" when expecting one of the following: ) , * &amp; | = - + </p>
</blockquote>

<p>i print the $sql to see how the values are going to:</p>

<p><code>BEGIN TWD_WEB_CRM.PESQUISA_CLIENTES(1,''BA','RJ','SC'','132','',:status,:refc); END;</code></p>

<p>so, this is how i'm passing with php to the procedure:</p>

<p><code>$sql = "BEGIN TWD_WEB_CRM.PESQUISA_CLIENTES(".$codemp.",'".$estados."','".$diac."','".$dian."',:status,:refc); END;";</code></p>

<p>the variable <code>$estados</code> receive: <code>'BA','RJ','SC'</code></p>

<p>so, my question is:</p>

<p>how can i pass this kind of string with <code>'</code> and <code>,</code> to my procedure using php ?</p>

<p>i try with <code>\</code>  but didin't work.</p>

<p>what i'm missing ?</p>

<p>any question, by my guest.</p>

<p>Thanks.</p>

<p><strong>Edit</strong></p>

<pre><code>  BEGIN TWD_WEB_CRM.PESQUISA_CLIENTES
  (

      1,
      ''BA','RJ','SC'',  // this supposed to be 1 field with strings...
      '132',
      '',
      :status,
      :refc
  ); 
  END;
</code></pre>
