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 laterInformation 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 |