title: How to use DBMS_CRYPTO.encrypt function in oracle
body: <p>I want to encrypt password column in the database and I am trying to use encrypt function present inside <code>DBMS_CRYPTO</code> package (have given execute access from sys account to the current user) but I am getting the following error.
  Please give me some examples of how to use this function:</p>
  
  <pre><code>select DBMS_CRYPTO.encrypt('12345', dbms_crypto.DES_CBC_PKCS5, 'A1') from dual;
  </code></pre>
  
  <p>Error:</p>
  
  <blockquote>
    <p>ORA-06553: PLS-221: 'DES_CBC_PKCS5' is not a procedure or is undefined
    06553. 00000 -  "PLS-%s: %s"</p>
  </blockquote>