title: how to call function in oracle
body: <p>how to call oracle function . i want to call below function but its show error i am new in oracle that's why i'm here</p>
  
  <pre><code>  Function CardExpiry(cardNO char) return date;
  </code></pre>
  
  <p>i am using below query but it's show error </p>
  
  <pre><code>SELECT * from SMIT.AUDIO_Service_Package.CardExpiry(:CARDNO) ;
  </code></pre>
  
  <p>error
   [Error: ORA-00933: SQL command not properly ended]</p>