Bug 53851 - 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'
Summary: Oracle CURSOR still returns : ORA-06553: PLS-306: wrong number or types of ar...
Status: RESOLVED INVALID
Alias: None
Product: JMeter - Now in Github
Classification: Unclassified
Component: Main (show other bugs)
Version: 2.7
Hardware: PC Windows XP
: P2 critical (vote)
Target Milestone: ---
Assignee: JMeter issues mailing list
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-09-11 15:01 UTC by rudi.chati
Modified: 2012-09-11 16:15 UTC (History)
0 users


Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description rudi.chati 2012-09-11 15:01:36 UTC 
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 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
Comment 1 Sebb 2012-09-11 15:28:13 UTC 
It looks like the 3rd parameter is not an INTEGER, so the error message is correct.
Comment 2 rudi.chati 2012-09-11 16:01:19 UTC 
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
Comment 3 Sebb 2012-09-11 16:15:45 UTC 
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.
Comment 4 The ASF infrastructure team 2022-09-24 20:37:51 UTC 
This issue has been migrated to GitHub: https://github.com/apache/jmeter/issues/2921