• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Menen Zwerky
Ranch Hand
Posts: 44
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 182
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic