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 188.8.131.52.0 and later
Information in this document applies to any platform.
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:
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