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: [email protected]
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]
