Oracle CURSOR still returns : ORA-06553: PLS-306: wrong number or types of arguments in call to 'WTRK11GET_1'ORA-06553: PLS-306: wrong number or types of arguments in call to 'WTRK11GET_1'

[asfimport]

rudi.chati (Bug 53851):
ORA-06553: PLS-306: wrong number or types of arguments in call to 'WTRK11GET_1'

here is the request in the Tree Results screen

[Callable Statement] call WTRK_PACKAGE.WTRK11GET_1(?,?,?)

AX44189C,0,0
VARCHAR,INTEGER,INTEGER

(Note : I put INTEGER out opf the suggestion from the BUG that was declared fixed in Bug 2008 - 4657
I also tried other variations including OUT 1111, etc)

here is the procedure def in Oracle:

PROCEDURE WTRK11GET_1 (P_WTRK_CIN_IN_VCIN_ID IN VARCHAR2, P_STATUS_OUT OUT NUMBER, p_recordset OUT refcursor);

The JDBC driver class used in the JDBC connection
oracle.jdbc.driver.OracleDriver

See also attachments screenshots.

Any ides how I can solve this. I don't really need at this point the CURSOR value, just need to be able to run this as performance test.

Thanks,
Rudi

Severity: critical
OS: Windows XP

[asfimport]

Sebb (migrated from Bugzilla):
It looks like the 3rd parameter is not an INTEGER, so the error message is correct.

[asfimport]

rudi.chati (migrated from Bugzilla):
Teh question is, I know it is not INTEGER, I was just tryign different things becasue CURSOR was not asccepted either - it returned INVALID TYPE

PROCEDURE WTRK11GET_1 (P_WTRK_CIN_IN_VCIN_ID IN VARCHAR2, P_STATUS_OUT OUT NUMBER, p_recordset OUT refcursor);

Here again the call

[Callable Statement] call WTRK_PACKAGE.WTRK11GET_1(?,?,?)

AX44189C,0,0
VARCHAR,INTEGER,CURSOR

and here the result

Thread Name: WRTS SELECTs 1-1
Sample Start: 2012-09-11 11:59:43 EDT
Load time: 1
Latency: 0
Size in bytes: 25
Headers size in bytes: 0
Body size in bytes: 25
Sample Count: 1
Error Count: 1
Response code: null 0
Response message: java.sql.SQLException: Invalid data type: CURSOR

Response headers:
oracle.jdbc.driver.T4CConnection@ca8f43

SampleResult fields:
ContentType: text/plain
DataEncoding: UTF-8

[asfimport]

Sebb (migrated from Bugzilla):
For help with using JMeter, in the first instance please read the manual.

If you cannot find the answer there, please subscribe to the JMeter user list and post there.

Bugzilla is not a support forum.