Home » Other » General » Advantages of Type Objects over Packages (11g)
Advantages of Type Objects over Packages [message #492831] Wed, 02 February 2011 23:49 Go to next message
adarshsp
Messages: 2
Registered: February 2011
Location: Bangalore
Junior Member

Hello there,
I wanted to know what advantes would i get by using an OO approach while designing my system than using stored procedures (packages)
For eg. i have a process flow called Category( From creation to Being published and the intermediate actions involved in the lifecycle of the category process flow).

now, what advantes would i have if i created an Type Object which would house all the methods related to this flow and then utilize it, over creating a stored procedure(package) to do the same.


It will be really helpful to have an insight into this!!! Cool
Re: Advantages of Type Objects over Packages [message #492832 is a reply to message #492831] Wed, 02 February 2011 23:58 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I wanted to know what advantes would i get by using an OO approach while designing my system than using stored procedures (packages)
I suggest you are asking the WRONG question.

What about the disadvantages of trying to combine RDBMS with OO?

The combination flies as well as a BRICK flies.
Re: Advantages of Type Objects over Packages [message #492834 is a reply to message #492832] Thu, 03 February 2011 00:07 Go to previous messageGo to next message
adarshsp
Messages: 2
Registered: February 2011
Location: Bangalore
Junior Member

Oops! i meant using Objects in PL/sql(RDBMS) only not in any other programming language, the desing of the sytem is in oracle i.e business logic.
Re: Advantages of Type Objects over Packages [message #492847 is a reply to message #492834] Thu, 03 February 2011 01:00 Go to previous messageGo to next message
Michel Cadot
Messages: 67956
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can now stop to repeat the same question, 5 times is sufficient to get it.

Regards
Michel

[Updated on: Thu, 03 February 2011 01:00]

Report message to a moderator

Re: Advantages of Type Objects over Packages [message #492868 is a reply to message #492847] Thu, 03 February 2011 04:06 Go to previous message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
I suspect everyone on this site is of the same opinion as blackswan - no advantage exists.
Previous Topic: Loading data from OLTP schema to star schema
Next Topic: NEW FEATURES IN ORACLE 11G
Goto Forum:
  


Current Time: Tue Sep 28 21:29:33 CDT 2021