Script in Oracle unsuccessful in execution

I have the following situation:

I want to run scripts in Oracle, using JDBC Request in Jmeter. Connection configuration is now ok.

When I run the script, I get error. And detail: The same script within PL/SQL is successfully executed. Error: "java.sql.SQLSyntaxErrorException: ORA-00911: invalid character".

Does anyone know why?

Script:

SELECT *FROM TBJDALRT_ALERTA_TP;

Prints below (script and error).

enter image description here

Thank you!

CodePudding user response：

Remove ; from your statement. Executing several SQL statements in one JDBC Request sampler is not supported, you either need to switch to JSR223 Sampler and Groovy language and invoke Statement.executeBatch() function or go for 2 separate JDBC Request samplers.

More information: Apache Groovy - Working with a relational database