Hi Mike, I've tried that and the sequence stays the same - no increment I've also tried removing the 'view tree results' and no change.
RD
From: Michael Stover <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: JMeter Users List <[EMAIL PROTECTED]> Subject: RE: calling a stored procedure Date: Thu, 12 Aug 2004 10:15:42 -0400
When I run oracle procedures via jdbc, it's like this:
call ab_test()
-Mike
On Thu, 2004-08-12 at 09:44, Rita danger wrote:
> Hi Craig,
>
> Yes the 'Select ab_seq.nextval from dual;' works in the JDBC request?
> But it does not seem to call the procedure
>
> Thanks
> RD
>
> >From: [EMAIL PROTECTED]
> >Reply-To: "JMeter Users List" <[EMAIL PROTECTED]>
> >To: [EMAIL PROTECTED]
> >Subject: RE: calling a stored procedure
> >Date: Thu, 12 Aug 2004 09:30:49 -0400
> >
> >Can you run the ab_test select statement in a JDBC request successfully?
> >
> >Craig
> >
> >-----Original Message-----
> >From: Rita danger [mailto:[EMAIL PROTECTED]
> >Sent: Thursday, August 12, 2004 7:40 AM
> >To: [EMAIL PROTECTED]
> >Subject: RE: calling a stored procedure
> >
> >
> >Hi
> >
> >Still having problems trying to run a procedure in jmeter.
> >I have tried BEGIN ab_test(); END;
> >
> >ab_test is a procedure which gets the next sequence value from dual.
> >So after running 'BEGIN ab_test(); END;' in jmeter, the sequence does not
> >increment.
> >Therefore it didn't work.
> >Please advise
> >
> >RD
> >
> >
> >
> > >From: [EMAIL PROTECTED]
> > >Reply-To: "JMeter Users List" <[EMAIL PROTECTED]>
> > >To: [EMAIL PROTECTED]
> > >Subject: RE: calling a stored procedure
> > >Date: Tue, 10 Aug 2004 10:00:29 -0400
> > >
> > >yes, I did it for both Oracle and SQL Server.
> > >
> > >
> > >Oracle example
> > >BEGIN run_get_availability(); END;
> > >
> > >SQL Server example
> > >exec run_get_availability
> > >
> > >
> > >
> > >Craig
> > >
> > >-----Original Message-----
> > >From: Rita danger [mailto:[EMAIL PROTECTED]
> > >Sent: Tuesday, August 10, 2004 9:53 AM
> > >To: [EMAIL PROTECTED]
> > >Subject: calling a stored procedure
> > >
> > >
> > >Hi I'm new to jmeter
> > >Can you call a stored procedure in Jmeter
> > >thank you
> > >RD
> > >
> > >_________________________________________________________________
> > >Want to block unwanted pop-ups? Download the free MSN Toolbar now!
> > >http://toolbar.msn.co.uk/
> > >
> > >
> > >---------------------------------------------------------------------
> > >To unsubscribe, e-mail: [EMAIL PROTECTED]
> > >For additional commands, e-mail: [EMAIL PROTECTED]
> > >
> > >---------------------------------------------------------------------
> > >To unsubscribe, e-mail: [EMAIL PROTECTED]
> > >For additional commands, e-mail: [EMAIL PROTECTED]
> > >
> >
> >_________________________________________________________________
> >Want to block unwanted pop-ups? Download the free MSN Toolbar now!
> >http://toolbar.msn.co.uk/
> >
> >
> >---------------------------------------------------------------------
> >To unsubscribe, e-mail: [EMAIL PROTECTED]
> >For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >---------------------------------------------------------------------
> >To unsubscribe, e-mail: [EMAIL PROTECTED]
> >For additional commands, e-mail: [EMAIL PROTECTED]
> >
>
> _________________________________________________________________
> Want to block unwanted pop-ups? Download the free MSN Toolbar now!
> http://toolbar.msn.co.uk/
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
--
Michael Stover <[EMAIL PROTECTED]>
Apache Software Foundation
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
_________________________________________________________________
It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
