• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Mapping Advanced Oracle DataType
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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
References: 
 >Mapping Advanced Oracle DataType (From: Metal Metal <email@hidden>)

  • Prev by Date: Re: Unable to release locks when using MultiECLockManager
  • Next by Date: Problem on WOLips
  • Previous by thread: Mapping Advanced Oracle DataType
  • Next by thread: Question about missing close tag
  • Index(es):
    • Date
    • Thread