Re: pl/sql alternatives for server side programming?

On Oct 24, 5:29 pm, Aya the Vampire Slayer <ry..._at_gatech.rmv.this.part.edu> wrote:
> m..._at_pixar.com wa:
>
> >If you look at postgresql, they have the idea of pluggable scripting
> >languages, so you can write server side code in tcl, python, etc.
> >Is there an equivalent idea in Oracle?
> >Are there any alternatives to PL/SQL for Oracle server-side programming?
> >Can java be used?  
>
> Yes, Java. From 8i, I think(?).http://www.oracle.com/technology/sample_code/tech/java/jsp/oracle9ijs...http://www.developer.com/db/article.php/3337411http://www.devarticles.com/c/a/Java/Java-Stored-Procedure-in-Oracle-D...
>
> --
> "Care must be exorcised when handring Opiticar System as it is apts to
> be sticked by dusts and hand-fat." --Japanese Translators
>
> "Keep your fingers off the lens." --Elton Byington, English Translator

SQL Server 2005 on supposts what is basically .net in the database and like Oracle inclusion of java in the database I think it is a bad idea. I would stick with PL/SQL if at all possible since it is well interfaced to the database and it works well for handling most data related tasks. You can use external procedures if you really need to call a module to handle something you cannot do in PL/SQL. When you start using all these other languages you made maintaining your application very difficult because programmers are going to find themselves having to deal with one feature/process that ends up having pieces in several different languages. Debugging is a nightmare.

IMHO -- Mark D Powell -- Received on Fri Oct 24 2008 - 19:32:43 CDT