Re: Writing PL/SQL in Java.

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 A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org