RE: java, etc

Joe,

    I am working on the same thing right now. Tom Kyte's book has excellent examples.

1. Yes, you must have java loaded. Run the initjvm.sql script, after you make sure your java_pool_size is big enough (at least 100m). If it fails, it is a PAIN to back out and requires a bounce. This is well documented.
2. No, an external listener is not required. You do need privileges granted or the JAVASYSPRIV role.
3. The Oracle doc is okay. Tom's book is much better.

And the obligatory (with sincere thanks for all your contributions) :  

RTFM!   Dan Fink

-----Original Message-----
Sent: Monday, October 07, 2002 11:39 AM
To: Multiple recipients of list ORACLE-L

Ok one of my last tasks here(besides implementing RMAN) is to tell the developers how to call an external java program from like pl/sql.
(unix-based)
 

Does this require me to have java loaded in the database(from what i've read I dont think so).  

Does this require me to have an external proc listener(i think so, and have a .so file?).  

What would be the best part of the oracle docs to be able to answer these questions for myself, with some examples if possible to show the developers?  

thanks, joe  

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Fink, Dan
  INET: Dan.Fink_at_mdx.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).