Error running Oracle script in F8 and automation mode

Question

I have the following problem:

I'm automating some scripts in Oracle using Jmeter. I'm getting an error in Jmeter the same way when I use F8 to execute in PL/SQL. F5 mode works normally.

can you help me?

Script and print below:

SELECT *FROM TABLEONE; SELECT *FROM TABLETWO;

Why this error? Could anyone help?

Thanks in advance

Answer 1

I don't know what is "F8", when it comes to JMeter you can only execute one statement at a time in the JDBC Request sampler.

If you need to run 2 - either go for 2 JDBC Request samplers or switch to JSR223 Sampler and Groovy language where you will be able to use Statement.addBatch() and Statement.executeBatch() functions