java.sql.SQLException:There are no other data to be read into the socket

[Menen Zwerky]

Hello I wrote this store procedure

create or replace


PROCEDURE SpListEvents
( p_startDate IN TIMESTAMP , p_endDate IN TIMESTAMP ,p_duration IN NUMBER,
p_ListEvents OUT ListEventsCrs, p_result OUT NOCOPY NUMBER, p_resultMessage OUT NOCOPY VARCHAR2)

IS
sql_select VARCHAR2(4000);
BEGIN


sql_select:='SELECT * FROM SERVICES.NOTES_ORGANIZER where NOR_DURATION = :3';

open p_ListEvents for sql_select;


EXCEPTION WHEN OTHERS THEN
p_result:=-20011;
p_resultMessage:='Error in procedure SpListEvents: ' || p_resultMessage || ' :' || sqlerrm;
ROLLBACK;

END SpListEvents;



Caused by: java.sql.SQLException: Non vi sono altri dati da leggere nel socket
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1118)
at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1070)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:478)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:215)


Where is the fault? where could be the error in my code?
Thanks Menen

[Fatih Keles]

sql_select:='SELECT * FROM SERVICES.NOTES_ORGANIZER where NOR_DURATION = :3';
You declare bind variables in the above statement but you don't assign anything with USING so it is null. This procedure will not return any data (ref cursor ) in pl/sql or java.