Re: Writing PL/SQL in Java.

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sun, 03 Jun 2007 11:38:50 +0200
Message-ID: <f3u768$459$1@news4.zwoll1.ov.home.nl>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

DA Morgan wrote:
> Mr. X. wrote:

>> So you don't sugest using mixing java in PL/SQL.
>> O.K.
>>
>> B.T.W - It was just for curiosity that there may be another syntax for
>> PL/SQL,
>> and what benefites can I make of using Java.
>>
>> And, no - I didn't find good example on google (which obviously I will
>> find my own message as this one).
>>
>> Thanks :) 

>
> Java is intended for front-ends and requires a skill set not normally
> found in database developers and DBAs. The code tends to be slower and
> more difficult to maintain.
>
> There are a few things Java can do that can not be done in SQL, PL/SQL,
> or utilizing Oracle's built-in packages and when that is the case it
> makes sense to use it. Otherwise Java, in the database, makes as only
> slightly more sense as feathers on a fish.

Daniel, you miss something here.

There's a LOT of java in the Oracle database nowadays. Not just because Oracle is a strong supporter of Java (I question some solutions, that have been rewritten in Java from PL/SQL), but because some things just can be done easier.

Ever tried to read an OS directory listing? Ever tried to send mail with attachments? (Why would you want to do that from within a database?!?)

I could go on. Just take a look under the Oracle RDBMS hood and find out how much of the oracle Supplied Packages are actually java. So maybe there is no need to write something yourself (in whatever language), just because it's already there. But do realize: a lot of what is already there, is Java.

And to the OP - Java in the database uses PL/SQL wrappers. In that sense, it is not to avoid that you mix PL/SQL and Java. - --
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGYowqLw8L4IAs830RAm4GAJ4vxDYK0PtnbTkXMh38elklrRfWgACfflO6 NNrOsUFtiU+LDplS3+oN1Wg=
=BSb/
-----END PGP SIGNATURE----- Received on Sun Jun 03 2007 - 04:38:50 CDT