How can java run the oracle procedure?


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: How can java run the oracle procedure?

  1. #1
    Yun Guest

    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?






  2. #2
    MarkN Guest

    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
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center