Thanks. My SP is returning a ref cursor. Here is the code: DECLARE P_BANK_HOLIDAYS_O <schema_name>.<package_name>.bank_holiday_cur_type; BEGIN P_BANK_HOLIDAYS_O := NULL; <schema_name>.<package_name>.GET_BANK_HOLIDAYS (P_BANK_HOLIDAYS_O); END;
I tried the following combinations: 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 Then I tried: Parameter Values - NULL Parameter Types - OUT <schema_name>.<package_name>.bank_holiday_cur_type Variable Names - P_BANK_HOLIDAYS_O Error Message - ORA-01006: bind variable does not exist Any ideas? rpaliath wrote: > > Hi, I am quite new to jmeter and have been working on executing some PLSQL > stored procedures using it. I had a question. After the stored procedure > is executed, all I see on the Response Data is the following message - "-1 > updates. Output variables by position:" > > How do I see the output from these stored procedures. I tried the > following commands but I still keep getting the same message. > DBMS_OUTPUT.ENABLE; > DBMS_OUTPUT.PUT_LINE(<out_variable>); > > I am using jmeter version 2.3.4 r785646 and I am connecting to Oracle 10g. > Please let me know what am I doing wrong here. > > Thanks. > Rajiv > -- View this message in context: http://www.nabble.com/Output-from-a-stored-procedure-tp25530750p25530815.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]
