Call Stored Procedure Returning Cursor as Output

[carina caoor]

Hi i am trying to call a stored procedure that returns ref cursor as out parameter but i am getting null pointer Exception suggest me where am i doing wrong

Stored Procedure

create or replace
PROCEDURE   SP_PDC_TEST_5(p_CustomerID IN CHAR  DEFAULT NULL,p_rpt_cursor OUT cr_package.cr_cursor)
   IS
    --p_Firstname varchar(255);
  
        BEGIN
        OPEN p_rpt_cursor FOR
        SELECT acct_id from ci_acct_per where per_id=p_CustomerID;
        END;



    

My Servlet code Snippet that calls stored procedure is

 

d= new OracleDatabaseConnectionDEV();
      		connection=d.connect();
            
         	connection.setAutoCommit(false);
         	
         	
   		   		
   		stmt = connection.prepareCall(" { call SP_PDC_TEST_5(?,?) }" );
   		
   		stmt.setString(1,"5444000000");
   		stmt.registerOutParameter(2, OracleTypes.CURSOR);
   	 	[b]stmt.execute();[/b]
   	 	
   	 	rs=(ResultSet)stmt.getObject(2);
   	 	while(rs.next())
   	 	{
   	 		
   	 		String acctid=rs.getString(1);
   	 		
   	 		System.out.println("Account ID "+acctid);
   	 		
   	 	}
   	 
        }
        catch(Exception e)
        {
        	error=e.toString();
        	e.printStackTrace();
        }
        

   

Error i am getting is

java.lang.NullPointerException
at oracle.jdbc.ttc7.TTCAdapter.newTTCType(TTCAdapter.java:300)
at oracle.jdbc.ttc7.TTCAdapter.createNonPlsqlTTCColumnArray(TTCAdapter.java:270)
at oracle.jdbc.ttc7.TTCAdapter.createNonPlsqlTTCDataSet(TTCAdapter.java:231)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1927)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1119)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2191)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2064)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2989)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:658)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:736)
at postDatedCheque.CallStoredProc.doGet(CallStoredProc.java:54)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Unknown Source)





showing error at stmt.execute().