July 24, 2008 at 10:56 am
hello to all
i ve created a variable using a select statement to retrieve certain values from the oracle database.
Now in the source OLE DB component i have another oracle table whose values i am trying to retrieve using the variable such as
where application_id =?
but when i press the parameter button it gives me an error that it can not retrieve its information from the sql command.
if i do the same process using the sql server table as a source table it would go to the parameter list and i can select the parameter
what seems to be the problem i dont understand
please help
thanx
July 25, 2008 at 4:35 am
Hi Hasysf,
Why don't you just use a variable evaluated as an expression to build your SQL command? Then you can forget about the parameters, and what's better is that you can view the variable value at runtime which is great for debugging...
HTH
Kindest Regards,
Frank Bazan
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply