Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Need to compile and execute plsql files from remote machine

Need to compile and execute plsql files from remote machine

From: Anand <aanandiyer_at_yahoo.com>
Date: 6 Feb 2004 02:10:02 -0800
Message-ID: <3a4f5b39.0402060210.537c81fc@posting.google.com>

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 Received on Fri Feb 06 2004 - 04:10:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US