Skip to Main Content
Forums

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Associative array parameter from c# - handling Null element values

987862Sep 8 2020 — edited Sep 9 2020

I am sure others have run into it but I could not manage to locate an answer. The answers on the web seem to relate to NULL array rather than null values inside the array elements.

In this simplified example - let's say I have defined the following types in my Package...

     TYPE t_NUMBER IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

    TYPE t_VARCHAR IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;

I am providing an input Associative Arrays of types t_NUMBER and  t_VARCHAR as parameters from my c# code to my stored procedure with Oracle.ManagedDataAccess.dll. Some of my elements in the arrray(s) supplied as value for the parameters need to be null as I am representing rows in the table with the arrays. What value should the null elements have?DbNull.Value ? Something else?

Many thanks!

Comments

NickR2600-Oracle

Ha ha, I love how curious and thorough you are!  I'm certain the files are meta-data and scripts which tell NetBeans what files it needs, how they should be organized, and how to compile them.  I've tried messing around with them a few times in order to convert a Java SE 8 project to be a Java SE 9 Modular project.  But I had trouble figuring out all the places that needed changing.  Other than that, I haven't needed to dig too deeply into the role of each file, so I'm not sure which resources would be best.  I'll ask around.

1 person found this helpful
NickR2600-Oracle

Hopefully I'll be able to reach one of the product managers to provide thoughts here on the forum.  In the meantime, they said the information on each file was google-able piece-wise and recommended this stackoverflow thread as an example: https://stackoverflow.com/questions/33772118/difference-between-build-xml-and-build-impl-xml

1 person found this helpful
1 - 2

Post Details

Added on Sep 8 2020
#odp-net
3 comments
625 views