Hi Gino, I give such parameters in JDBC request like ${query} also the column name as ${UserId} and pass these values in "User Parameters" and run it and I get the required query.
-----Original Message----- From: Gino Gargiulo [mailto:[EMAIL PROTECTED] Sent: Saturday, March 12, 2005 12:45 AM To: jmeter-user@jakarta.apache.org Subject: JDBC Request question > Hi, > > I was wondering if I could get some help with JDBC requests. > What I am trying to do is perform a Select statement to the database > but in the select statement, I need to pass in a variable and a field > to search for. I created the variable and try ${UserName} into the > SQL statement but I get back the following error > > ORA-06550:line1,column 588: PL/SQL:ORA-00984: column not > allowed here ORA-065550:line 1, column 463:PL/SQL SQL Statement > ignored > > Is this at all possible? Is there any samples of scripts that > send a JDBC request with variables in the SQL statement? > > Any help is greatly appreciated > > > > Regards, > > Gino --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]