[SOLVED] DataSource Step (Oracle) -> ORA-00911
Hello,
creating a datasource Step using the wizard generates a sql statement in the sql query textbox, which ends with a ;
Trying to test this using "get the first x rows from datasource" results in an Oracle error ORA-00911 "invalid character" message.
Removing the ; from the generated sql statement solves the problem. It seems that soapui adds a second ; when executing the statement. Executing a sql statement which ends with two ;; results in the above mentioned Oracle error.
=> soapui shoul not add a second ; to the statement or generate the sql statement without a ; at end of the statement.
Environment: soapUI 3.0.1 Pro , Oracle 10g (10.2.0.3) latest oracle 10.2.0.3 JDBC thin driver (ojdbc14.jar).
BR,
Alexander Knauer
creating a datasource Step using the wizard generates a sql statement in the sql query textbox, which ends with a ;
Trying to test this using "get the first x rows from datasource" results in an Oracle error ORA-00911 "invalid character" message.
Removing the ; from the generated sql statement solves the problem. It seems that soapui adds a second ; when executing the statement. Executing a sql statement which ends with two ;; results in the above mentioned Oracle error.
=> soapui shoul not add a second ; to the statement or generate the sql statement without a ; at end of the statement.
Environment: soapUI 3.0.1 Pro , Oracle 10g (10.2.0.3) latest oracle 10.2.0.3 JDBC thin driver (ojdbc14.jar).
BR,
Alexander Knauer
