[SOLVED] DataSource Step (Oracle) -> ORA-00911

[Tieto_Deutschla]

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

[SmartBear_Suppo]

Hi,

Thank you for pointing that out.
With the latest nightly build you'll get wizard version that will not add ';' to the end of the query.

Regards,
/Dragica
eviware.com

[Tieto_Deutschla]

Fixed. It works. Thank you.

[SmartBear_Suppo]

Great!

Thanks for reporting!

/Ole
eviware.com