Re: Java and 8i question

A copy of this was sent to mikegrof_at_rocketmail.com (if that email address didn't require changing) On Sun, 24 Oct 1999 03:06:03 GMT, you wrote:

>Hi all,
>
>What are the limitations of Java stored procedures? Can they be
>graphical?

Not really, doesn't make sense -- you are running the database, perhaps 2 or three tiers away from a console. The GUI doesn't have any place to show itself.

>Can they do file I/O?

Yes, the full range of IO operations are available (files, sockets, etc)

> Any setup like utl_file?

Not needed. Java has IO routines. You'll just open files and write to them.

> What can
>you do with Java that you can't do with PL/SQL?

there are quite a few things. One thing that pops into mind is tcp/ip sockets. PL/SQL as yet does not have a native interface to sockets. You can write one in C and call that from plsql. Java has native support for sockets. This for example lets you take the mail package from Sun, compile it into the database and lets java send an email using smtp.

> I'm a little confused
>on how Oracle can support the full features of the Java language.
>

any specific questions?

>Thanks.
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sun Oct 24 1999 - 08:41:03 CDT