hi,
i wrote java code using pl/sql developer.
now i need to deploy it to some other instances and would like to do it
on the commandline.
is there a way to do so?
i found loadjava, but then i need to compile the code on my client, not
in oracle.
is there a way to let oracle load the source and compile it itself?
thnx
thomas

On 20 mrt, 12:00, Thomas Peter <braindum... (AT) expires-31-03-2007 (DOT) news-
group.org> wrote:
Not exactly sure of the problem you have,
but you can do this from a SQL session:

create or replace and compile java source named "your_code" as
import ....;
public class {...
}

Call it, using a wrapper like a procedure:

create or replace procedure my_proc( p_in_param in varchar2 )
as language java
name 'your_code';
/

frank.van.bortel (AT) gmail (DOT) com wrote:
yes, i did this using a gui. worked fine. i call it using a function,
works fine as well.

but how do i deploy this code to another db-instance via script.
i can't do a @scriptname in sqlplus (i receive an error about invalid
characters)
an when i use loadjava i have to compile the code before i load it,
which i don't want neither.

so is there a way to get the java-(source)code from a commandline
(without a gui) in the database.
(calling the code is no prob, since i can call functions or procedures
that call the java from sqlplus)

thnx,
thomas

On 21 mrt, 15:06, Thomas Peter <braindum... (AT) expires-31-03-2007 (DOT) news-
group.org> wrote:
Your GUI tool must use some special characters - it should run
from a command line (aka script) as well - I do it that way.
Maybe a simple (notepad?) tool will show the offending characters?

Post the command, and the exact error from the sqlplus session.

frank.van.bortel (AT) gmail (DOT) com wrote:
no it doesn't. i have an & in my java-code and this is the problem.

is there a way to escape this?

Thomas Peter wrote:

set define off

solves the problem!

sorry for the noise