How can java run the oracle procedure?

[Yun]

I defined a procedure in my oracle db, and I try to run it through my java
program.
con = DriverManager.getConnection(URL,"webuser","webuser");
sql = "execute main_job_wxi.job_initial('FEB2002')";
prepStmt = con.prepareStatement(sql);
prepStmt.execute();
but failed

java.sql.SQLException: ORA-00900: invalid SQL statement

How could I conquer this problem?

[MarkN]

Been awhile since I did Oracle Stored Procs and never via Java. Did you try
removing the 'execute' from the statement?

Mark


"Yun" <Yun.Y.Hu@seagate.com> wrote:
>
>I defined a procedure in my oracle db, and I try to run it through my java
>program.
> con = DriverManager.getConnection(URL,"webuser","webuser");
> sql = "execute main_job_wxi.job_initial('FEB2002')";
> prepStmt = con.prepareStatement(sql);
> prepStmt.execute();
>but failed
>
>java.sql.SQLException: ORA-00900: invalid SQL statement
>
>How could I conquer this problem?
>
>
>
>
>