Forum Stats

  • 3,727,563 Users
  • 2,245,413 Discussions
  • 7,852,877 Comments

Discussions

ODI Variable CLOB Data Issue

I have created a variable 'HTML_BODY' with the data type as 'text'. I have also put a default value. I'm trying to have the variable to hold clob data (which is retrieved from a SQL query). When I try to refresh the variable it gives me the error below. I have also tried changing the data type of the column to varchar2(4000 char) with no luck. Please advise as to how can I make it work.

SQL QUERY: SELECT HTML_BODY FROM schema.AUDIT_HTML

Also, tried this with no luck.

SELECT SUBSTRB( DBMS_LOB.SUBSTR( HTML_BODY, 4000, 1 ), 1, 4000) HTML_BODY FROM schema.AUDIT_HTML

ERROR DETAILS:

java.lang.Exception: ODI-17511: No value to be set to variable 'BOAT.HTML_EMAIL'.

at oracle.odi.runtime.agent.execution.sql.RefreshVariableExecutor.execute(RefreshVariableExecutor.java:75)

at oracle.odi.runtime.agent.execution.sql.RefreshVariableExecutor.execute(RefreshVariableExecutor.java:27)

at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:52)

at oracle.odi.runtime.agent.execution.VariableSessionTask.processTask(VariableSessionTask.java:192)

at oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:117)

at oracle.odi.runtime.agent.execution.VariableSessionTask.doExecuteTask(VariableSessionTask.java:164)

at oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:886)

at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2225)

at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:610)

at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:718)

at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:611)

at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)

at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doProcessStartAgentTask(TaskExecutorAgentRequestProcessor.java:800)

at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$1400(StartSessRequestProcessor.java:74)

at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:702)

at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:180)

at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:108)

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

at oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)

at oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)

at java.util.concurrent.FutureTask.run(FutureTask.java:266)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

at java.lang.Thread.run(Thread.java:745)

Sign In or Register to comment.