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 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:            no            yes            yes           yes           yes
18.3                 no
19.3                 no




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

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