This discussion is archived
0 Replies Latest reply: Nov 22, 2012 3:03 AM by 971957 RSS

Problem: Null values in "ref" attributes - c# odp type factory

971957 Newbie
Currently Being Moderated
Hi folks,

I'm using the odp.net type factory (class IOracleCustomType and the specific annotations...)
to map udts to c# classes.

By now I had no problems with it, because I've never used "ref" attributes within the udts.

Now I need the use of "ref" attributes within udts but it seems that the odp factory cannot
handle those references.

For example:_*

A Simple Type:
create or replace type bookcontent_t force as object (
    id number(20)
  , name varchar2(1000)
);
*And a collection with references to objects of this type:*
create or replace type fms_bookcontent_ref_cln force as table of *ref* bookcontent_t;
The c# class is generated by odp.net.

When I retrieve data by using odp.net I get a collection with the correct number of
elements but the values are null.

What can I do to solve this problem with "ref" attributes/lists? How can I get the referenced object instances?

Thanks for your help....

Kind regards

Patrick

Edited by: 968954 on 22.11.2012 02:57

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points