title: Timestamp values not inserting sometime in oracle
body: <p>The timestamp value in Stored procedure is <code>'30-APR-14 12.00.00.000000 AM'</code>.<br>
  The parameter list:</p>
  
  <pre><code>XXXXX(
     P_CAT_PRG_ID     NUMBER,
     P_CATALOG_ID     NUMBER,
     P_PRG_ELE_ID     NUMBER,
     **P_ELE_CLOSE_DATE TIMESTAMP**,
     -- P_UNIT_PACK      NUMBER,
     P_UNIT_PRICE NUMBER,
     P_CURRENCY   VARCHAR2,
     P_CREATED_BY NUMBER
     ) AS
  </code></pre>
  
  <p>While executing this sp in "Oracle sql developer" I am giving the value as <code>'03/Apr/14'</code>.</p>
  
  <p>The insert query inside that sp:</p>
  
  <pre><code>INSERT INTO CCCXXXX
        (CAT_PRG_ID,
         CATALOG_ID,
         PRG_ELE_ID,
         ELE_CLOSE_DATE,
         UNIT_PRICE,
         CURRENCY,
         CREATED_BY,
         CREATED_DATE)
      VALUES
        (0,
         P_CATALOG_ID,
         P_PRG_ELE_ID,
         P_ELE_CLOSE_DATE,
         P_UNIT_PRICE,
         P_CURRENCY,
         P_CREATED_BY,
         SYSTIMESTAMP);
  </code></pre>
  
  <p>The Error:</p>
  
  <blockquote>
    <p>ORA-01830: date format picture ends before converting entire input string</p>
  </blockquote>
  
  <p>Could you please help me ...</p>