Re: import java on cli

frank.van.bortel_at_gmail.com 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 {...
> }

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 _at_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 Received on Wed Mar 21 2007 - 15:06:23 CET