wood burning stoves 2.0*
The moose likes Oracle/OAS and the fly likes java.sql.SQLException:There are no other data to be read into the socket Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "java.sql.SQLException:There are no other data to be read into the socket" Watch "java.sql.SQLException:There are no other data to be read into the socket" New topic
Author

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

Menen Zwerky
Ranch Hand

Joined: Aug 06, 2010
Posts: 44
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

Joined: Sep 01, 2005
Posts: 182

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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: java.sql.SQLException:There are no other data to be read into the socket
 
Similar Threads
java.sql.SQLException
testing a stored procedure
Oracle custom object from java
c3po, hibernate, oracle database problem
Problem with storing document as blob