title: Get BLOB from stored procedure in Oracle
body: <p>This is my stored procedure:</p>
  
  <pre><code>CREATE OR REPLACE
  PROCEDURE prodecureName
    (
      firstArgument IN NUMBER,
      secondArgument OUT BLOB )
  AS
  BEGIN
    SELECT secondArgument 
    INTO prodecureName.secondArgument 
    FROM tableName
    WHERE firstArgument = prodecureName.firstArgument ;
  END;
  </code></pre>
  
  <p>Data type of secondArgument column is valid (both are BLOB).
  During executing this procedure I get this error:</p>
  
  <blockquote>
    <p>Wrong number or types of arguments in call to prodecureName</p>
  </blockquote>
  
  <p>How I can get blob from stored procedure?</p>