running a stored procedure that takes a long type argument, execute returns false
<p>My call for stored procedure is</p>

<pre><code>public void executePreProcssService()
{
    try
    {

        Connection conn = null;
        MasterReportUtils masterReportUtils = new MasterReportUtils();

        List&lt;Model&gt; masterReportList = masterReportUtils.getPendingMasterReportList();

        if (masterReportList != null &amp;&amp; masterReportList.size() &gt; 0)
        {

            conn = getConnection();

            MasterReport masterReport = null;

            for (Model model : masterReportList)
            {

                masterReport = (MasterReport) model;

                CallableStatement st = conn.prepareCall("{call MasterReport_SP(?)}");

                st.setLong(1, masterReport.getRecNo());

                st.execute();
                st.close();
            }
        }
        executeReportService(conn);

        if (conn != null)
        {
            conn.close();
            conn = null;
        }
    }
    catch (Exception e)
    {
    }
}
</code></pre>
