Re: PL/SQL vs. Java

The way to go, is definitely Java. The next versions of Oracle apps(Self_Service) are going to be rewritten in Java from PL/SQL so this is a good indicator.

"Karl R." <kreitsch_at_zdnetonebox.com> wrote in message news:07e17c9a.fdefd998_at_usw-ex0102-016.remarq.com...
> The big advantage of PL/SQL for us is this very easy
> implementation of a procedural language!
> We decided to prefer PL/SQL before C++ for our batch-programs.
>
> PL/SQL has very good advantages against C++/Java
>
> * Cursor-For-Loops ( Implicit handling of predefined Cursors )
> * Easiest EXCEPTIION-Handling ( No need for defining an
> Execption-Class )
> * Supplied Packages
> * It is easier to implement than java
> * It fits more to the relational model as java ( no support of
> derived qulifiers in java, you have to map them in PL/SQL )
> * The VM of java is still buggy
>
> In future Java and his embedded sql-enhancement could come
> nearer to the advanteges of PL/SQL. I think Java with its
> concepts is great; but oracle has to implement a better
> interface into the rdbms, for direct use of java-features;
>
> Or oracle implements additional features like package derivation
> ( base-packtes and child-packages ) ?
> Just in time -Compile for PL/SQL ?
> ..
>
>
>
>
> Karl Reitschuster
> Senior Consultant CSC Ploenzke AG
> Oracle Databases, Implementation, Performance-Tuning
> <!Jesus is Lord!>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
 *
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Thu Jun 08 2000 - 00:00:00 CDT