Re: PL/SQL vs. Java

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 Wed Jun 07 2000 - 00:00:00 CDT