Re: Ask for suggestion on Object Oriented Feature of PL/SQL?

In my experience, OO programming in PL/SQL is not worth the overhead, both in performance losses and the clunky syntax. The OO features are bolt ons to PL/SQL since PL/SQL is not truly an OO language - it is based on Ada. I would recommend using PL/SQL
with good coding practices -> packages, good naming conventions, well written SQL, etc. If you truly need OO features, I would recommend using Java based stored procedures. However, for transactional performance, PL/SQL gives the best results.

I would recommend using each language for what it does best. In my experience it is best to use PL/SQL stored procedures, packages, and functions for direct interaction with database, pick another language for the middleware, and then rely on JavaScript for doing client side validations for minimizing unnecessary interactions with the servers.

Good Luck!

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Chris Weiss
mailto:chris_at_hpdbe.com
www.hpdbe.com
High Performance Database Engineering
Available for long and short term contracts


"Norris Sze" <hk1_at_hotmail.com> wrote in message
news:abg2ug$7ir5_at_imsp212.netvigator.com...


> I am going to develop a new system with Oracle database for my company. In

> my mind, object oriented methodology is the best way to go. So I suggest

> Java (servlet and JSP) programming language to my boss. But the suggestion

> was turned down by my boss. He insisted that PSP (PL/SQL) is the way to

go.


> Of course, I have to follow his direction because he is the boss. However,

I


> learned from the reference material that PL/SQL features OO too.

>

> Is there anyone who has used OO feature of PL/SQL before? Is it stable and

> easy to debug?

>

> If there is a lot of problem with OO feature of PL/SQL, I would rather

write


> plain procedural program with PL/SQL.

>

> Thanks in advance!

>

>