RE: Stored Procedure failure on JDBC test run

2009-06-22 Thread AL BUNDY
g that the above call command should be closer right? Thanks > Date: Fri, 5 Jun 2009 18:32:46 +0100 > Subject: Re: Stored Procedure failure on JDBC test run > From: seb...@gmail.com > To: jmeter-user@jakarta.apache.org > > On 05/06/2009, AL BUNDY wrote: > > > >

Re: Stored Procedure failure on JDBC test run

2009-06-05 Thread sebb
orrect format or tell me > 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 &g

RE: Stored Procedure failure on JDBC test run

2009-06-05 Thread AL BUNDY
09 23:14:21 +0100 > Subject: Re: Stored Procedure failure on JDBC test run > From: seb...@gmail.com > To: jmeter-user@jakarta.apache.org > > On 04/06/2009, AL BUNDY wrote: > > > > Hi, > > Thanks for your response. I'm afraid that link points to the way to crea

Re: Stored Procedure failure on JDBC test run

2009-06-04 Thread sebb
On 04/06/2009, AL BUNDY 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 stored procedure > that triggers multiple SQL queries. > > I guess my issue is how to do the right SYNTAX with Jm

RE: Stored Procedure failure on JDBC test run

2009-06-04 Thread AL BUNDY
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 stored procedure that triggers multiple SQL queries. I guess my issue is how to do the right SYNTAX with Jmeter. I understand the concept and logic, just

Re: Stored Procedure failure on JDBC test run

2009-06-04 Thread sebb
On 04/06/2009, AL BUNDY wrote: > > > > > > > > > > > > > > > > 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();

Stored Procedure failure on JDBC test run

2009-06-04 Thread AL BUNDY
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: