An error...

[Coral_Lover]

Hi, does anybody know what's wrong with the codes below? Coz i get an error.

String str;

str = "CREATE TABLE Application " +
"(App_ID VARCHAR(50) PRIMARY KEY,Name VARCHAR(100),App_Info VARCHAR(500)," +
"Group_ID VARCHAR(50),Location VARCHAR(50),Cost_Center VARCHAR(50), " +
"FOREIGN KEY (Group_ID) REFERENCES Grp (Grp_ID) ON DELETE SET NULL ON UPDATE " + "CASCADE)";
stmt.executeUpdate (str);

The error:

javax.servlet.ServletException: ORA-00907: missing right parenthesis

at org.apache.jasper.runtime.PageContextImpl.handlePageException(Unknown Source)
at jsp.mqadmin.inventory.CreateAppTable_8._jspService(CreateAppTable_8.java:97)
at org.apache.jasper.runtime.HttpJspBase.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java)
at org.apache.tomcat.facade.ServletHandler.doService(Unknown Source)
at org.apache.tomcat.core.Handler.invoke(Unknown Source)
at org.apache.tomcat.core.Handler.service(Unknown Source)
at org.apache.tomcat.facade.ServletHandler.service(Unknown Source)
at org.apache.tomcat.core.ContextManager.internalService(Unknown Source)
at org.apache.tomcat.core.ContextManager.service(Unknown Source)
at org.apache.tomcat.modules.server.Http10Interceptor.processConnection(Unknown Source)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(Unknown Source)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(Unknown Source)
at java.lang.Thread.run(Thread.java:484)

[glenngv]

output the sql to the browser to see what's missing.

out.print(str);
stmt.executeUpdate (str);