OracleArrayDataReader / Instantiate Class
Posted: Tue 25 Mar 2008 17:09
I'm using an actual trial version of your product for getting an overview if it's usable in our project.
My questions are:
1)
With "Oracle Package Wizard" I've generated an access class for a package.
The result parameter of one package function (GetPicklists) is casted to "OracleArrayDataReader" which seems to be undocumented.
What is the difference to a normal OracleDataReader ?
2)
The result on the PL/SQL side is an Oracle type named "PicklistTT". The hierarchy is:
-- Picklist Entry
CREATE OR REPLACE TYPE PentryT IS OBJECT ( ...)
-- All entries of a Picklist
CREATE OR REPLACE TYPE PentryTT IS TABLE OF PentryT;
-- A Picklist
CREATE OR REPLACE TYPE PicklistT IS OBJECT (
entries PentryTT
...
);
-- All Picklists
CREATE OR REPLACE TYPE PicklistTT IS TABLE OF PicklistT;
A result of this type is returned from the function. I've generated the necessary classes for it with "Oracle Object Wizard".
How do I get the data from OracleArrayDataReader into an aray or a list of my C# PicklistT object?
Thanks,
Andreas
My questions are:
1)
With "Oracle Package Wizard" I've generated an access class for a package.
The result parameter of one package function (GetPicklists) is casted to "OracleArrayDataReader" which seems to be undocumented.
What is the difference to a normal OracleDataReader ?
2)
The result on the PL/SQL side is an Oracle type named "PicklistTT". The hierarchy is:
-- Picklist Entry
CREATE OR REPLACE TYPE PentryT IS OBJECT ( ...)
-- All entries of a Picklist
CREATE OR REPLACE TYPE PentryTT IS TABLE OF PentryT;
-- A Picklist
CREATE OR REPLACE TYPE PicklistT IS OBJECT (
entries PentryTT
...
);
-- All Picklists
CREATE OR REPLACE TYPE PicklistTT IS TABLE OF PicklistT;
A result of this type is returned from the function. I've generated the necessary classes for it with "Oracle Object Wizard".
How do I get the data from OracleArrayDataReader into an aray or a list of my C# PicklistT object?
Thanks,
Andreas