Mailing-List: contact jmeter-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "JMeter Users List" <jmeter-user@jakarta.apache.org>
Received-SPF: pass (athena.apache.org: domain of z004836@hotmail.com
 designates 65.54.246.176 as permitted sender)
Message-ID: <BAY115-W402A27478CD0345417689FBC4B0@phx.gbl>
Content-Type: multipart/alternative;
	boundary="_a2a3a01a-70bd-44ed-9991-f92a553c3c74_"
From: AL BUNDY <z004836@hotmail.com>
To: <jmeter-user@jakarta.apache.org>
Subject: RE: Stored Procedure failure on JDBC test run
Date: Thu, 4 Jun 2009 21:00:20 +0000
Importance: Normal
In-Reply-To: <25aac9fc0906041243w5c2c1933l6d834543934974a5@mail.gmail.com>
References: <BAY115-W516015934E9CB455654E9EBC4B0@phx.gbl>
 <25aac9fc0906041243w5c2c1933l6d834543934974a5@mail.gmail.com>
MIME-Version: 1.0

--_a2a3a01a-70bd-44ed-9991-f92a553c3c74_
Content-Type: text/plain; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable


Hi=2C
Thanks for your response. I'm afraid that link points to the way to create =
a simple SQL query. I already did that and now need to do the stored proced=
ure that triggers multiple SQL queries.
I guess my issue is how to do the right SYNTAX with Jmeter.  I understand t=
he concept and logic=2C just need to know the actual required way to write =
the proc.
Thanks


> >  Hello=2C
> >  I am attempting to run an existing stored procedure on Jmeter
> >  passing a variable to it. I keep getting diff exception errors on the
> >  result tree using these 3 popular commands.
> >
> >
> >  1- BEGIN
> >  GET_USER_BY_EMAIL_SP()=3B end=3B  Throws SQLException: ORA-06550: line=
 1=2C
> >  column 7: PLS-00201: identifier 'GET_USER_BY_EMAIL_SP' must be declare=
d
> >  (On this one=2C  I placed the variable  in the lower Jmeter cell as
> >  VARCHAR)
> >
> >  2-DECLARE
> >  sireT7@WTC.com VARCHAR(40)=3B
> >  BEGIN SYSTEM_ADMIN_PKG.GET_USER_BY_EMAIL_SP()=3B Throws : java.sql.SQL=
Exception: ORA-06550: line 3=2C column 7:
> >  PLS-00306: wrong number or types of arguments in call to 'GET_USER_BY_=
EMAIL_SP
> >
> >  3- BEGIN GET_USER_BY_EMAIL_SP(sireT7@WTC.com)=3BEND=3B throws : java.s=
ql.SQLException: ORA-06550: line 3=2C column 7:
> >  PLS-00306: wrong number or types of arguments in call to 'GET_USER_BY_=
EMAIL_SP
> >
> >  Also should I include the package name on the path? BEGIN SYSTEM_ADMIN=
_PKG.GET_USER_BY_EMAIL_SP=3B
> >  This throws: java.sql.SQLException: ORA-06550: line 1=2C column 7: PLS=
-00306: wrong number or types of arguments.
> >  Im not sure if/when to insert the variable on the parameter value/type=
 below and just been testing both ways to no avail.
> >  Can someone please help me get a clue.
>=20
> http://jakarta.apache.org/jmeter/usermanual/component_reference.html#JDBC=
_Request
>=20
> See "SQL Query" which has an example stored procedure call.
>=20
> >  Thanks in advance
> >
> >
> >  _________________________________________________________________
> >  Lauren found her dream laptop. Find the PC that=92s right for you.
> >  http://www.microsoft.com/windows/choosepc/?ocid=3Dftp_val_wl_290
>=20
> ---------------------------------------------------------------------
> To unsubscribe=2C e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands=2C e-mail: jmeter-user-help@jakarta.apache.org
>=20

_________________________________________________________________
Lauren found her dream laptop. Find the PC that=92s right for you.
http://www.microsoft.com/windows/choosepc/?ocid=3Dftp_val_wl_290=

--_a2a3a01a-70bd-44ed-9991-f92a553c3c74_--