Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Instance of retrieved UDT is always the same when UDT is null

Patrick KernFeb 8 2024

Hi,

i use version 23.3.1-dev of ODP.CORE.

in our business application there are a few types with inheritance.

PROJEKT_KALK_TABLE_TYPE (table of PROJEKT_KALK_TYPE → BASIS_TYP (contains VARCHAR2_TAB))

PROJEKT_KALK_TYPE also contains “PROJEKT_KALK_DEF_TABLE_TYPE” (table of PROJEKT_KALK_DEF_TYPE → BASIS_TYP (contains VARCHAR2_TAB))

see attached script for db-objects.

types.sql

when retreaving this types (via package EX1.read_type) the “null”-instances of VARCHAR2_TAB are all the same. this is an problem, because the inherit-classes are different.

i illustrate the problem with a sample code:

programm.txt

is there a way that each instance is different (even the UDT is null or not null)?

thanks

Comments
Post Details
Added on Feb 8 2024
3 comments
46 views