PDA

View Full Version : Oracle OBJECTs

EdwardP
04-25-02, 14:35
Hello,

Has any one used object-oriented features of PL/SQL?

I know you can do something like the following.

CREATE TYPE employee AS OBJECT (...)

My biggest concern is performance: Do the objects in Oracle negatively affect performance? Anything else I should be aware of?

Thanks in advance,
Edward
alligatorsql.com
04-25-02, 15:21
Hello Edward,

when you use TYPE for accessing or handling datas the performance will not change. Thatīs what we find out in our projects.
The benefit of using types is accesing complex datas very handy and often with one select.

Regards

Manfred Peter
(Alligator Company)
http://www.alligatorsql.com