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 > > > > > > > > > _________________________________________________________________ > > > Lauren found her dream laptop. Find the PC that’s right for you. > > > http://www.microsoft.com/windows/choosepc/?ocid=ftp_val_wl_290 > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [email protected] > > For additional commands, e-mail: [email protected] > > > > > _________________________________________________________________ > Lauren found her dream laptop. Find the PC that’s right for you. > http://www.microsoft.com/windows/choosepc/?ocid=ftp_val_wl_290 --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
