Re: Embed Java in Stored Proc?

From: Todd Gillespie <toddg_at_linux127.ma.utexas.edu>
Date: 4 Apr 2001 07:13:45 GMT
Message-ID: <9aehj9$28l$1@geraldo.cc.utexas.edu>

Ed & Deanna Jennings <jenningse_at_mindspring.com> wrote:
: Is is possible to embed Java source code into a stored
: procedure? Since Java provides infinitely more flexibility in regard to
: OS level communications and devices, it would be really useful to embed
: Java into PL/SQL code in a stored procedure. I'm not talking about Java
: Stored Procedures. More like the equivalent of embedded SQL in a 3 GL.

This question is a little odd - do you want to just stick Java source into the src for a PL/SQL block, and compile the resulting mess cleanly? If so, then, no, it's not supported nor is it likely to be. To get the job done:
You can write procs & functions in Java; you can call these procs & funcs from with [PL/]SQL blocks. Why aren't you calling Java functions from SQL? You need to invest more time in application design and less in finding new language tools. Received on Wed Apr 04 2001 - 02:13:45 CDT