Re: Mapping Advanced Oracle DataType
Re: Mapping Advanced Oracle DataType
- Subject: Re: Mapping Advanced Oracle DataType
- From: Don Lindsay <email@hidden>
- Date: Wed, 30 Apr 2008 05:28:33 -0400
Hello;
The short answer is no, not as a true object. You can do it through
JDBC but that would be the hard way and circumvent EO. However since
these types of objects are relational (I.E. a column in a table) you
can create an entity that uses an sql statement to retrieve rows from
the database and use:
select * from the ( select <yourobjectfieldgoeshere> from
<yourtablenamethatcontainsthecolumn where ...);
If you want to pull all the relations in a table created as
mytable (
phone_person number(10) constraint pk_mytable_person PRIMARY KEY,
phonedata phonetable)
NESTED TABLE phone_table store as mytable_phonetable;
you would do:
select a.phone_person, b.a_code, b.p_number from mytable a,
table(phonedata) b as the query your entity should use to retrieve rows.
After you type in the SQL, you will need to create a insert, update,
and delete procedures and add them to your entity to allow EO to
interact with the entity as if it is a table. You then need to add
your attributes to your entity.
Please let me know if you have any further questions.
Don
On Apr 30, 2008, at 12:28 AM, Metal Metal wrote:
Hi All,
How can I map a user defined oracle datatype (eg. an array of oracle
objects) in EO Modeler ?
For example:-
CREATE OR REPLACE TYPE phone_object AS OBJECT (
a_code CHAR(3),
p_number CHAR(8));
/
CREATE OR REPLACE TYPE PHONE_TABLE IS TABLE OF phone_object;
/
How can I map this PHONE_TABLE in EO Modeler ?
TIA
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
@mac.com
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden