From: Todd Gillespie Newsgroups: comp.databases.oracle.server Subject: Re: Embed Java in Stored Proc? Date: 4 Apr 2001 07:13:45 GMT Organization: The University of Texas at Austin; Austin, Texas Lines: 16 Message-ID: <9aehj9$28l$1@geraldo.cc.utexas.edu> References: <3ACA3680.FA60FD2A@mindspring.com> NNTP-Posting-Host: linux127.ma.utexas.edu X-Trace: geraldo.cc.utexas.edu 986368425 2325 146.6.139.98 (4 Apr 2001 07:13:45 GMT) X-Complaints-To: abuse@cc.utexas.edu NNTP-Posting-Date: 4 Apr 2001 07:13:45 GMT User-Agent: tin/pre-1.4-19990805 ("Preacher Man") (UNIX) (Linux/2.2.17 (i686)) Ed & Deanna Jennings 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.