Oracle JDBC Connector: Error message ORA-17010: Closed ResultSet:

Identity Security Cloud (ISC) ISC Discussion and Questions
1

Hey,
When we are running an Oracle stored procedure using a cursor as parameter, we have an partial result set with the following error message:

sailpoint.connector.ConnectorException: ORA-17010: Closed ResultSet: next ORA-17010 - Database Error Messages

Result set size is not consistent:

image
image953×419 10.9 KB

Driver used:

image
image743×93 1.92 KB

Query used:

image
image962×256 4.18 KB

Any idea how to fix this error?

Thanks.
Regards,

2

Hi @soquina,

This looks like an issue with the stored proc you are calling.

Have you checked with the DB team if the stored procedure is designed correctly to handle cursors and does not close them prematurely.? The cursor should remain open until all data is fetched.

1 Like
3

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.