-
How can java run the oracle procedure?
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?
-
Re: How can java run the oracle procedure?
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?
>
>
>
>
>
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Development Centers
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center
|