This discussion is archived
2 Replies Latest reply: Jan 20, 2013 8:54 AM by 984374 RSS

ODI evaluate variable

aetl Explorer
Currently Being Moderated
Hi everyone,

I have a question about evaluate variable:

Now For example I have a variable:

-No history

İn select -----Select first_name from hr.employees where employee_id=106 (it returns 'Valli')

Then Second variable:

--No history
Select--- SELECT '#VAR_FILE_NAME' from dual where substr('#VAR_FILE_NAME',1,1)='V'

Now in my package #VAR_FILE_NAME is refreshing variable

#VAR_CONTROL is evaluate variable and compare condition is ='#VAR_FILE_NAME'

if true then write a table else write false table.

I want to compare two string.

But always it is going to false table

Where Did I made mistake?

Thanks your reply



  • Correct Answers - 10 points
  • Helpful Answers - 5 points