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!

Assigning long text values to ODI variable

Matthias HeilosOct 2 2009 — edited Oct 6 2009

Hi all,

I want to store the error message of the previous step in a variable: _<%=odiRef.getPrevStepLog("MESSAGE")%>_ (using ODI 10.1.3.5 on Oracle 9i).

If I refresh the variable using a statement like Select '<%=odiRef.getPrevStepLog("MESSAGE")%>' From dual , it errors out if the message has more than 4K characters.

I tried to use _<%=odiRef.getPrevStepLog("MESSAGE").substring(0,3999)%>_ , but this creates an indexoutofbounds exception if the message has less than 4K characters.

I tried to use assign instead of refresh, but it only prints the jython code instead of retrieving the variable. How can I assign the message to a variable?

Thanks,
Matt

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 3 2009

Added on Oct 2 2009

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

9 comments

5,645 views