'Testing a stored procedure in JMeter - format error

I am trying to test an Oracle Stored Procedure in JMeter. I have already done the configuration to the DB successfully, but when I call the stored procedure and send the parameters, I have a format error, apparently, the JMeter is not sending the parameters as I configure them.

SP-JMETER:

This is the error:

ERROR:

As you can see, the parameters reach the stored procedure, and it processes it, but apparently, I'm not sending them right.

In this way I execute the stored procedure in the PL/SQL Developer:

SP-PLSQLDEV:

And let me know if you need any more information.

w_trans_date: = substr (w_in, 1, 8); / * left (w_in, 8); */

Solution 1:^[1]

Try to w_trans_date: = substr('28372873822327', 1, 8); If this code will work properly, see on value in w_in variable.

Solution 2:^[2]

I solved the issue by adding the following line to the INIT SQL STATEMENTS of the JDBC CONNECTION CONFIGURATION:

alter session set nls_date_format = 'dd / mm / yyyy'

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	iEfimoff
Solution 2	MrMythical

'Testing a stored procedure in JMeter - format error

Solution 1:[1]

Solution 2:[2]

Sources

Related Questions

Solution 1:^[1]

Solution 2:^[2]