469,603 Members | 2,069 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,603 developers. It's quick & easy.

Need to compile and execute plsql files from remote machine

Hi all,

I have a requirement of - checking the syntax, compiling and executing
the plsql files (procedures, functions, triggers etc) from a remote
machine. I use JAVA for development and i had tried using jdbc
connection.

CallableStatement stmt;
::::::::::
stmt = connection.prepareCall("Begin ... end;"); //Anonymous procedure
stmt.execute();
:::

The above snippet does not give any compilation/syntatical errors. It
will be better if there is any other means to access the database and
execute the procedure with all the behaviour of sqlplus. I would
appreciate any guidence in this regard.

Thanks in advance.

Regards,
Srikanth.R
Jul 19 '05 #1
0 2024

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by GrantMagic | last post: by
22 posts views Thread by Ramon F Herrera | last post: by
reply views Thread by guiromero | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.