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]