The sql is fine, I sent in the same request replacing the ${Username}
with a value 'test' and the statement ran fine.Are there any samples of this where it is working? -----Original Message----- From: Peter Lin [mailto:[EMAIL PROTECTED] Sent: Friday, March 11, 2005 11:19 AM To: JMeter Users List Subject: Re: JDBC Request question I'm guessing the sql statement was bad. can you look at Oracle's network log and see what the query was. peter On Fri, 11 Mar 2005 11:14:39 -0800, Gino Gargiulo <[EMAIL PROTECTED]> wrote: > > > 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
