well then replicate the values into your Jmeter. for e.g. In your java client is this "CALL <SCHEMA_NAME>.<PACKAGE_NAME>.GET_BANK_HOLIDAYS (P_BANK_HOLIDAYS_O)" what you specify in the query for callable statement?
Is "Parameter Types - OUT <SCHEMA_NAME>.<PACKAGE_NAME>.bank_holiday_cur_type" what you specify in your type?-- shouldnt this be an integer? regards deepak On Tue, Sep 22, 2009 at 12:42 PM, rpaliath <[email protected]> wrote: > > I am able to execute this SP from a Java client as well as from an oracle > client. > > > > rpaliath wrote: > > > > 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-tp25530843p25530879.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] > >
