RE: object tables

Hi Sean and List

Yes, you are right. AFAIK Oracle does not support inheritance for objects in PL/SQL environment. You can use Java. I read that Oracle introduced 'client-side object cache' for 8.0 and upwards ( It appears as additional service for NT). There are corresponding OCI calls to use it. Oracle declares that one of the advantages of using the cache is opportunity to get a set of related objects (graph or tree of objects) in a one call from server. If someone from List had experience of working with client-side object cache it would be very interesting to hear an overall opinion.

Thanks

Ed

>
>
> Hi Folks,
>
> Ed, I must have been reading your mind as I was creating
> this post when
> digest arrived!. I've also got the same curiosity as Ed. Whilst
> recognition of objects in Oracle, make developers life
> easier I'm curious
> too about performance. I suspect Oracle jumped on the
> Object backwagon and
> provide the functionality but I wonder if there is a genuine
> practical
> application in use out there. Anyone seen any papers on
> this subject?. I
> believe Oracle does not support Inheritance for Objects, can
> anyone confirm
> this to me please.
>
> Sean :)
>
> ###### ###### ###### ######
> # # # # # # # # Rookie
> #### # # ###### ###### Data
> # # # # # # # # Base
> # # ####### ###### # # Adminstrator
> -------------------------------- ------------
> Organon (Ireland) Ltd.
> E-mail: sean.oneill_at_organon.ie [subscribed: Digest Mode]
>
> Visit: http://www.egroups.com/group/Oracle-OCP-DBA
>
> The only man who never makes a mistake is the man who never
> does anything.
> - Theodore Roosevelt
>
>
> >------------------------------------------------------------
> >
> > From: "Shevtsov, Eduard" <EShevtsov_at_flagship.ru>
> > Date: Thu, 2 Nov 2000 11:04:06 +0300
> > Subject: object tables
> >
> >Hello List
> >
> >Can anyone share experience of working with object tables?
> I'm interested
> in
> >your opinions. Are they fast enough? Is there some
> performance degradation
> >of retrieving data from object tables vs rel. tables ?
> >
> >
> >Thanks in advance
> >
> >Ed
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: O'Neill, Sean
> INET: Sean.ONeill_at_organon.ie
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access /
> Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Fri Nov 03 2000 - 05:39:54 CST