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. 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 > > sir...@wtc.com 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(sir...@wtc.com);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: jmeter-user-unsubscr...@jakarta.apache.org > For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org > _________________________________________________________________ Lauren found her dream laptop. Find the PC that’s right for you. http://www.microsoft.com/windows/choosepc/?ocid=ftp_val_wl_290
