Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

variable declaration ignores refresh SQL

jhall_uk_reduxDec 3 2012 — edited Dec 3 2012

Hi,

I'm using ODI 11.1.1.5 and I am running a previously created package that has a 'declare variable' step. There is no separate 'refresh variable' step in the package. The SQL query is defined in the refreshing tab of this variable and is valid and returns a value as expected from the db if run directly. However, when running the package, the variable does not show a new entry in the History tab for the current execution - only the variable value from a previous execution is stored.

Why doesn't the current value get shown?

Cheers,
John

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 31 2012

Added on Dec 3 2012

#business-intelligence-applications, #data-integrator, #system-management-and-integration

7 comments

133 views