getProcedureColumns MetaData no Longer Returns Element Data Type For PL/SQL Table Types
(Doc ID 1265195.1)
Last updated on DECEMBER 21, 2022
Applies to:
JDBC - Version 10.2.0.4 and laterInformation in this document applies to any platform.
Symptoms
Prior to JDBC 10.2.0.4 it was possible to look up stored procedure information using the getProcedureColumns method and determine the data type of the elements of a PL/SQL collection type used as a argument in a stored procedure.
The getProcedureColumns returned 2 rows for the column, one row indicating that the argument type is a collection, the next row indicating that what the collection element's data type is such as VARCHAR2, NUMBER, etc.
Example:
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 |
References |