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
AMTo: Multiple recipients of list ORACLE-LSubject: 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