RDBPROD: Calling an external procedure/function using JDBC gives %RDB-E-BAD_DB_HANDLE, Invalid Database Handle
(Doc ID 1442398.1)
Last updated on JANUARY 06, 2020
Applies to:Oracle Rdb Server on OpenVMS - Version 7.2 to 22.214.171.124 [Release 7.2]
Oracle JDBC for Rdb - Version 7.2 and later
Information in this document applies to any platform.
In an Rdb database, an external function is defined that itself uses the same Rdb database. The external function performs some DML and a COMMIT or ROLLBACK.
This external function is used in a JAVA program or application that uses JDBC to connect to the database using a normal RdbThin server. The first session that uses this external function in the database works correctly each time the function is used.
However a second (and third and so on) session always results in the error:
This happens for a 3th, 4th, and subsequent sessions, as long as the same Thinserver process is used.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document