Hi, I am trying to call a stored procedure using jmeter (Version - 2.3.4
r785646) and hitting all kind of errors. I have been using some posts to try
various combinations:

SQL Query - CALL <SCHEMA_NAME>.<PACKAGE_NAME>.GET_BANK_HOLIDAYS
(P_BANK_HOLIDAYS_O)
Parameter Values - NULL
Parameter Types - OUT -10
Variable Names - P_BANK_HOLIDAYS_O
Error Message - ORA-06576: not a valid function or procedure name

SQL Query - CALL <SCHEMA_NAME>.<PACKAGE_NAME>.GET_BANK_HOLIDAYS
(P_BANK_HOLIDAYS_O)
Parameter Values - NULL
Parameter Types - OUT <SCHEMA_NAME>.<PACKAGE_NAME>.bank_holiday_cur_type
Variable Names - P_BANK_HOLIDAYS_O
Error Message - Invalid data type:
<SCHEMA_NAME>.<PACKAGE_NAME>.bank_holiday_cur_type

SQL Query - CALL <SCHEMA_NAME>.<PACKAGE_NAME>.GET_BANK_HOLIDAYS
(P_BANK_HOLIDAYS_O)
Parameter Values - NULL
Parameter Types - OUT 10
Variable Names - P_BANK_HOLIDAYS_O
Error Message - Invalid column type

Please help.

Thanks.
-- 
View this message in context: 
http://www.nabble.com/Calling-a-stored-procedure-tp25530843p25530843.html
Sent from the JMeter - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to