My Oracle Support Banner

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 7.2.5.1 [Release 7.2]
Oracle JDBC for Rdb - Version 7.2 and later
Information in this document applies to any platform.

Symptoms

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.

Cause

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
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.