My Oracle Support Banner

DatabaseMetadata.getProcedureColumns does not show the Datatype of a Function Return Value (Doc ID 2616161.1)

Last updated on AUGUST 09, 2023

Applies to:

JDBC - Version 11.2.0.4.0 and later
Information in this document applies to any platform.

Symptoms

The DatabaseMetadata.getProcedureColumns is used to get information about the datatypes of stored procedures.  If the stored procedure is a function then DatabaseMetadata.getProcedureColumns will also get the datatype of the return value of that function.

On some versions of the JDBC driver, only the parameters information is returned.  The datatype of the function's return value is missing.

DatabaseMetadata.getProcedureColumns is missing the datatype of the function's return value for the following versions:


11.1.0.7            no
11.2.0.1            yes
11.2.0.4            yes
12.1.0.2           yes
12.2.0.1           yes
18.3                 no
19.3                 no

Changes

 

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
Changes
Cause
Solution
References


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