Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Exception: No more data to read from socket ?

User_UM8AVJan 23 2020 — edited Jan 26 2020

Dear Experts,

in my ADF application I'm calling a stored procedure in the app module impl class as below:

	cst =
	this.getDBTransaction()
	.createCallableStatement("begin GET_SELECTED_USER_SP(?);end;", 0);

	cst.setObject("P_USER_ID", userId);
	cst.registerOutParameter("P_FLAG", Types.INTEGER);
	cst.execute();

But after executing this code I get the below error :

java.sql.SQLRecoverableException: No more data to read from socket

at oracle.jdbc.driver.T4CMAREngineStream.unmarshalUB1(T4CMAREngineStream.java:486)

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:414)

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)

at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:603)

at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:228)

at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:49)

at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1000)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1316)

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:5010)

I'm using Jdeveloper 12.2.1.2.

This post has been answered by Timo Hahn on Jan 23 2020

Jump to Answer

Added on Jan 23 2020

#application-development-in-java, #jdeveloper-and-adf

1 comment

322 views