Yes Certainly. I've been able to go and retrieve the actual calls. This is what I've been exactly typing in:
CALL rundates(); END; or just call rundate() I had at first used: begin SYSTEM_ADMIN_PKG.rundate end; but found that didnt run the procedure. At this point, am figuring 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: [email protected] > To: [email protected] > > On 05/06/2009, AL BUNDY <[email protected]> wrote: > > > > Yes, > > I just tried using that CALL - technique instead of BEGIN and get - : > > java.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 are > > for diff SQL .. I'm using Oracle db. So is it that there are multiple ways > > to call a proc on jmeter then? Given the 3 examples I described, am still > > unsure if there is a right or wrong way. > > Can one of the examples just be modified to the correct 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 > > > Subject: Re: Stored Procedure failure on JDBC test run > > > From: [email protected] > > > To: [email protected] > > > > > > > > On 04/06/2009, AL BUNDY <[email protected]> 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 Jmeter. I > > understand 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 > > > > > > [email protected] VARCHAR(40); > > > > > > BEGIN SYSTEM_ADMIN_PKG.GET_USER_BY_EMAIL_SP(); Throws : > > java.sql.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([email protected]);END; throws : > > java.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 > > SYSTEM_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 > > value/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.html#JDBC_Request > > > > > > > > > > See "SQL Query" which has an example stored procedure call. > > > > > > > > > > > Thanks in advance > > > > > > > > > > > > > > > > _________________________________________________________________ > > > > Windows Live™ SkyDrive™: Get 25 GB of free online storage. > > http://windowslive.com/online/skydrive?ocid=TXT_TAGLM_WL_SD_25GB_062009 > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > _________________________________________________________________ Bing™ brings you maps, menus, and reviews organized in one place. Try it now. http://www.bing.com/search?q=restaurants&form=MLOGEN&publ=WLHMTAG&crea=TEXT_MLOGEN_Core_tagline_local_1x1
