On 04/06/2009, AL BUNDY <[email protected]> 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(); 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]
