oracle parameter

  • 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

  • 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