Hi Deepak,
Attached is the procedure from PL_SQL. I thought this would help you better to examine the procedure. Could you please help me on what I should put on "JDBC Request" control panel to run this query? SQL Query: Parameter values: Parameter types: Thank you James ________________________________ From: Daly, James Sent: Thursday, October 22, 2009 10:14 AM To: 'JMeter Users List' Cc: Amira, Al Subject: FW: JMeter - How do i run a stored procedure Hi Deepak, Also, would it be possible to run the procedure "as is" from PL/SQL without adding any "parameter values" and "parameter types"? After I run procedure "as is" from PL/SQL as shown in a.) below I get "Response message: java.sql.SQLException: ORA-00907: missing right parenthesis." What does "missing right parenthesis" mean? a.)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); Thank you, James -----Original Message----- From: Daly, James Sent: Thursday, October 22, 2009 8:21 AM To: 'JMeter Users List' Subject: RE: JMeter - How do i run a stored procedure Hi Deepak, Thank you much for your response. You are correct, I removed the semi colon at the end and stopped getting "invalid character" on the View Results Tree". I have followed all your steps but have a question on how do I <FIND the integer value for SqlTypes.Other> as you mention below. Parameters types = VARCHAR, OUT <FIND the integer value for SqlTypes.Other> Can I just type in for Parameters types: VARCHAR, OUT But if I do this I get on "view result tree" - Response message: java.sql.SQLException: Invalid data type: OUT How can I fix this? Thank you. James -----Original Message----- From: Deepak Shetty [mailto:shet...@gmail.com] Sent: Wednesday, October 21, 2009 12:11 PM To: JMeter Users List Subject: Re: JMeter - How do i run a stored procedure 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 <da...@ibacorp.us> 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 > > da...@ibacorp.us > >
