Re: sqlplus functionality to run sql scripts in java (create, compile...)

Have you checked out Oracle's sqlj ?????

HTH,
Pete's

Christof Kaiser <kaiser_at_logiball.de> wrote in message news:<3E8AF51F.C5C50176_at_logiball.de>...
> Hi,
>
> I have a application where tables and pl/sql packages need to be
> created.
> Until now, this is done in sql scripts that are called from sqlplus,
> everything works fine.
>
> But I d like to use the same scripts from java.
> is there a component that does this for me?
> Its not hard to write a java class that runs the "create table"s etc
> from a file, but i also need to compile pl/sql and always want to check
> the status of the command / compilation.
>
> in short, i am re-implementing the sqlplus functionality in a java class
> where i can check if the stuff was run successfully.
>
> I found hensql add sourceforge, from which i might strip the
> functionality, but as i am using it in a comercial product i cant make
> my application GPL license.
>
> TIA
> christof
Received on Thu Apr 03 2003 - 08:38:39 CST