Choosing Between Java and PL/SQL
We have seen that stored procedures in Oracle8i can be written in Java as well as in PL/SQL. The natural question is how to decide which one to use for my procedural logic and data access. When deciding between PL/SQL and Java, you should determine the strengths of each language and then make the choice based on your exact situation. PL/SQL is good for tasks that involve manipulation of SQL data. This is because the data type system doesn't need any translation. Also, PL/SQL provides a large number of functions that enable you to manipulate SQL data. Java, on the other hand, provides a lot of power for computational operations. Program logic that involves extensive looping, exception handling, and conditional ...
Get e-Commerce Applications Using Oracle8i and Java from Scratch now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
