QuickTable | Thread - invalid sql statement??

QuickTable
Home \| API \| Tutorial \| Download \| Support \| Contact

QuickTable

User Cp | Register | Members | Search | Help

\|- QuickTable Discussion Forums > JDBC/Database Issues	Post New Topic Post A Reply
invalid sql statement??	printer friendly version next newest post \| next oldest post

Author	Messages
Screamer Private Gender: Male Location: Ukraine Registered: Nov 2006 Status: Offline Posts: 2	Posted Thursday, November 23, 2006 @ 18:44:32 i created procedure to insert row into my table and add it as insertSql: table.addInsertSql("exec addDetailDocument(?, ?, ?, " + documentid + ")", "4,6,5"); when i am trying to add a row a get ORA-00900: invalid SQL statement message box... any ideas why it happens? addDetailDocument procedure works well - i ve tested it many times.
Admin Board Owner Gender: Unspecified Location: Registered: Jul 2003 Status: Offline Posts: 9	Posted Friday, November 24, 2006 @ 18:33:47 Try removing the 'exec' from the sql. If you still get this error, try the other version of addInsertSql addInsertSql(java.sql.CallableStatement insertStatement, java.lang.String columnPointer)
Screamer Private Gender: Male Location: Ukraine Registered: Nov 2006 Status: Offline Posts: 2	Posted Saturday, November 25, 2006 @ 13:24:09 i tryed table.addInsertSql("begin; adddetaildocument(....) end;"); and it seems it work the way i want....

Post New Topic Post A Reply

Jump to:

All times are GMT -5 Hours.

Welcome to QuickTable Forums, Guest!

Username	:
Password	:

In order to fully utilize the abilities of this board, you are required to register as a member. Registration is free, and allows you to do lots of things including turning on or off certain features of this board. Register now!