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 (nike.apache.org: domain of sebbaz@gmail.com designates
 209.85.219.210 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type:content-transfer-encoding;
        b=gaR1MDXRoEmIJudE6cTmz4iyiHJ+LQodnmnvcrRqwRs+ktu7ytplYPbWfg14k9dHZ/
         WzronlGtOZGhGK3J5YHlQX80gBWYuIRVW5ZZN8g3lpL11ojw57NQMPTVM+dfeFD2lOHl
         zEyMlbjECazLFy36cX9RonE7d5blRToYExHeg=
MIME-Version: 1.0
In-Reply-To: <BAY115-W3297D1A90F1131C57404EABC480@phx.gbl>
References: <BAY115-W516015934E9CB455654E9EBC4B0@phx.gbl>
	 <25aac9fc0906041243w5c2c1933l6d834543934974a5@mail.gmail.com>
	 <BAY115-W402A27478CD0345417689FBC4B0@phx.gbl>
	 <25aac9fc0906041514r197cc71arf1df7c7008136f21@mail.gmail.com>
	 <BAY115-W3297D1A90F1131C57404EABC480@phx.gbl>
Date: Fri, 5 Jun 2009 18:32:46 +0100
Message-ID: <25aac9fc0906051032wc446f75o7462f5f214dda33d@mail.gmail.com>
Subject: Re: Stored Procedure failure on JDBC test run
From: sebb <sebbaz@gmail.com>
To: JMeter Users List <jmeter-user@jakarta.apache.org>
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

On 05/06/2009, AL BUNDY <z004836@hotmail.com> wrote:
>
>  Yes,
>  I just tried using that CALL - technique instead of BEGIN and get - : ja=
va.sql.SQLException: ORA-00911: invalid character.  Ref says its for Apache=
 derby.

What did you try exactly?

>  Also tried using EXEC or EXECUTE  before but made to understand those ar=
e for diff SQL .. I'm using Oracle db.  So is it that there are multiple wa=
ys to call a proc on jmeter then? Given the 3 examples I described, am stil=
l unsure if there is a right or wrong way.
>  Can one of the examples just be modified to the correct format or tell m=
e what to correct so I know the right syntax?

AIUI JDBC uses the same syntax for all databases.

As per the JMeter docs, this is either:

{CALL procedure(param)}
or
CALL procedure(param)

>  Thanks again
>
>
>  > Date: Thu, 4 Jun 2009 23:14:21 +0100
>  > Subject: Re: Stored Procedure failure on JDBC test run
>  > From: sebbaz@gmail.com
>  > To: jmeter-user@jakarta.apache.org
>
> >
>  > On 04/06/2009, AL BUNDY <z004836@hotmail.com> wrote:
>  > >
>  > >  Hi,
>  > >  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 store=
d procedure that triggers multiple SQL queries.
>  > >
>  > >  I guess my issue is how to do the right SYNTAX with Jmeter.  I unde=
rstand the concept and logic, just need to know the actual required way to =
write the proc.
>  >
>  > The referenced document has just such an example, though with more
>  > than one parameter:
>  >
>  > CALL SYSCS_UTIL.SYSCS_EXPORT_TABLE (null,?, ?, null, null, null)
>  >
>  > Have you tried calling your stored procedure using that syntax?
>  >
>  > >  Thanks
>  > >
>  > >
>  > >
>  > >  > >  Hello,
>  > >  > >  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(); end;  Throws SQLException: ORA-06550: =
line 1,
>  > >  > >  column 7: PLS-00201: identifier 'GET_USER_BY_EMAIL_SP' must be=
 declared
>  > >  > >  (On this one,  I placed the variable  in the lower Jmeter cell=
 as
>  > >  > >  VARCHAR)
>  > >  > >
>  > >  > >  2-DECLARE
>  > >  > >  sireT7@WTC.com VARCHAR(40);
>  > >  > >  BEGIN SYSTEM_ADMIN_PKG.GET_USER_BY_EMAIL_SP(); Throws : java.s=
ql.SQLException: ORA-06550: line 3, 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);END; throws : ja=
va.sql.SQLException: ORA-06550: line 3, 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 SYST=
EM_ADMIN_PKG.GET_USER_BY_EMAIL_SP;
>  > >  > >  This throws: java.sql.SQLException: ORA-06550: line 1, column =
7: PLS-00306: wrong number or types of arguments.
>  > >  > >  Im not sure if/when to insert the variable on the parameter va=
lue/type below and just been testing both ways to no avail.
>  > >  > >  Can someone please help me get a clue.
>  > >  >
>  > >  > http://jakarta.apache.org/jmeter/usermanual/component_reference.h=
tml#JDBC_Request
>  > >  >
>  > >  > See "SQL Query" which has an example stored procedure call.
>  > >  >
>  > >  > >  Thanks in advance
>  > >  > >
>  > >  > >
>
>  _________________________________________________________________
>
> Windows Live=99 SkyDrive=99: Get 25 GB of free online storage.
>  http://windowslive.com/online/skydrive?ocid=3DTXT_TAGLM_WL_SD_25GB_06200=
9

---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org