Analytics Software

Hi,

I have created an interface which extracts data from table and puts it into a flat file.
In that interface i have put a where clause which uses a ODI variable(customerid). I want to pass the variable value at run time.

customerid -
Datatype - Numeric, Action - Historize

i created a package -->Under Diagram tab :
1) drag and drop variable(customerid)
2) drag and drop interface
3) join them with ok link

Click on varible :
1) set Type : Declare Variable

Save the package.

Now i generate a scenario and when i execute the scenario, it does ask for input, but when i put in a value..it gives me " java.sql.SQLException: ORA-00936: missing expression
java.sql.SQLException: ORA-00936: missing expression"

2) set Type : Set Variable
Set a value "4" to the variable. execute the package. it gives me proper result.
Generate a scenario and when i execute the scenario, i put in a different value "2" and execute the sceanario. But it does not take in the new value(2)..it takes the same old value(4) and runs it.

3) When i run the scenario from java and give different variable values...it is running properly.

My concern is why is it not happening when i invoke the scenario from Designer.



Thanks.