Some observations a. The error you see is probably caused by the semi colon at the end. This shouldnt be there in java b. Second your call doesnt match the declaration. CALL CRIS_SYSTEM_ADMIN_PKG.CRIS_ > > GET_USERINFO_BY_EMAIL_SP(?,?) > Parameters types = VARCHAR, OUT <FIND the integer value for SqlTypes.Other> Parameter Values = siioTSC09, NULL
Note that i havent tested this out :) but the general principle is that as many '?' are needed as there are parameters c. As far as I know you cannot return OUT ref cursors in a form that can be processed by the JDBC sampler , i.e. you can execute the Stored proc but if you want to process the return resultset, you cant use the JDBC sampler. regards deepak On Wed, Oct 21, 2009 at 5:48 AM, Daly, James <[email protected]> wrote: > To whom it may concern, > > > > I am trying to call a stored procedure using jmeter (Version - 2.3.2) > and getting some errors. > > This SQL procedure which gets userinfo by e-mail for user: siioTSC09. > > Below is the actual procedure i used in JMeter and the procedure from > pl/sql viewer under packages. > > For "Parameter Values", I entered the username(not sure if this is > correct). > > > > Actual procedure i am using in JMeter JDBC Request control panel: > > CALL CRIS_SYSTEM_ADMIN_PKG.CRIS_GET_USERINFO_BY_EMAIL_SP(); > > > > Query Type: Callable statement > > Parameter values: siioTSC09 > > Parameter types: VARCHAR > > > > - Get the following message after running JDBX Request. > > Response message: java.sql.SQLException: ORA-00911: invalid character. > > > > > > Procedure from PL/SQL: > > CALL CRIS_SYSTEM_ADMIN_PKG.CRIS_GET_USERINFO_BY_EMAIL_SP(P_USER_EMAIL IN > VARCHAR2, > > P_REF_CURSOR OUT CRIS_GLOBAL_PARMS_PKG.T_REF_CUR); > > > > Can anyone help me with this? > > Thank you. > > > > Thank you, > > James Daly > > [email protected] > >
