wood burning stoves 2.0*
The moose likes JDBC and the fly likes Cannot perform fetch on a PLSQL statement: next Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Cannot perform fetch on a PLSQL statement: next" Watch "Cannot perform fetch on a PLSQL statement: next" New topic
Author

Cannot perform fetch on a PLSQL statement: next

bm mohan
Greenhorn

Joined: Oct 11, 2013
Posts: 7
Storedprocedure:

JDBC program:




Error:
java.sql.SQLException: Cannot perform fetch on a PLSQL statement: next
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147)
at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:192)
at stored_procedure.main(stored_procedure.java:32)
Balaji Manoharan Bm
Greenhorn

Joined: Sep 22, 2013
Posts: 13
Please refer this link
 
 
subject: Cannot perform fetch on a PLSQL statement: next
 
Similar Threads
java.sql.SQLException:There are no other data to be read into the socket
how to access cursor storedprocedure in JDBC program?
How to call oracle procedure and fetch returned data using Java?
Fetching multiple rows through stored procedure by preparecall method
Not able to use ResultSet properly