RE: java, etc

[Fink, Dan]

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----- From: JOE TESTA [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 11:39 AM To: Multiple recipients of list ORACLE-L Subject: java, etc 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