OWB Process Flow With SQLPLUS Activity Fails With RPE-01038: Failed to evaluate expression
(Doc ID 552144.1)
Last updated on AUGUST 01, 2019
Applies to:
Oracle Warehouse Builder - Version 10.2 and laterInformation in this document applies to any platform.
Symptoms
An OWB Process Flow with a SQLPlus Activity fails to execute with the error:
RPE-01038: Failed to evaluate expression declare "$LOOP_DETECT$" NUMBER := 0;function
"<LOAD_STG>" return VARCHAR2 is "ITEM_TYPE" VARCHAR2(4000) :=
(wb_rt_task_variable.get_value(299605));"ITEM_KEY" VARCHAR2(4000) :=
(wb_rt_task_variable.get_value(299607));"EVAL_LOCATION" VARCHAR2(4000) :=
(wb_rt_task_variable.get_value(299608));function "SQLPLUS" return VARCHAR2 is "WARNING" NUMBER :=
2;"RETURN_RESULT_NUMBER" NUMBER := NULL;"NUMBER_OF_ERRORS" NUMBER := 0;"SUCCESS" NUMBER :=
1;"ERROR" NUMBER := 3;"OK" NUMBER := 1;"FAILURE" NUMBER := 3;"AUDIT_ID" NUMBER :=299609;"RETURN_CODE" NUMBER := NULL;"NUMBER_OF_WARNINGS" NUMBER := 0;"RETURN_RESULT" VARCHAR(64)
:= NULL;"PARENT_AUDIT_ID" NUMBER := 299604;"OK_WITH_WARNINGS" NUMBER := 2;begin
"$LOOP_DETECT$" :=
"$LOOP_DETECT$" + 1;if "$LOOP_DETECT$" > 2 then raise_application_error(-20001, 'Loop
detected
calling "SQLPLUS"');end if;return to_char(
begin
null;
end;
/
exit);end;begin "$LOOP_DETECT$" := "$LOOP_DETECT$" + 1;if "$LOOP_DETECT$" > 2 then
raise_application_error(-20001, 'Loop detected calling "<LOAD_STG>"');end if;return
"SQLPLUS";end;begin :result := "<LOAD_STG>";end;.
Please modify the expression, redeploy and retry again.
"<LOAD_STG>" return VARCHAR2 is "ITEM_TYPE" VARCHAR2(4000) :=
(wb_rt_task_variable.get_value(299605));"ITEM_KEY" VARCHAR2(4000) :=
(wb_rt_task_variable.get_value(299607));"EVAL_LOCATION" VARCHAR2(4000) :=
(wb_rt_task_variable.get_value(299608));function "SQLPLUS" return VARCHAR2 is "WARNING" NUMBER :=
2;"RETURN_RESULT_NUMBER" NUMBER := NULL;"NUMBER_OF_ERRORS" NUMBER := 0;"SUCCESS" NUMBER :=
1;"ERROR" NUMBER := 3;"OK" NUMBER := 1;"FAILURE" NUMBER := 3;"AUDIT_ID" NUMBER :=299609;"RETURN_CODE" NUMBER := NULL;"NUMBER_OF_WARNINGS" NUMBER := 0;"RETURN_RESULT" VARCHAR(64)
:= NULL;"PARENT_AUDIT_ID" NUMBER := 299604;"OK_WITH_WARNINGS" NUMBER := 2;begin
"$LOOP_DETECT$" :=
"$LOOP_DETECT$" + 1;if "$LOOP_DETECT$" > 2 then raise_application_error(-20001, 'Loop
detected
calling "SQLPLUS"');end if;return to_char(
begin
null;
end;
/
exit);end;begin "$LOOP_DETECT$" := "$LOOP_DETECT$" + 1;if "$LOOP_DETECT$" > 2 then
raise_application_error(-20001, 'Loop detected calling "<LOAD_STG>"');end if;return
"SQLPLUS";end;begin :result := "<LOAD_STG>";end;.
Please modify the expression, redeploy and retry again.
It happens even with a very simple (empty) script in the SCRIPT parameter of the SQLPLUS activity:
begin
null;
end;
/
exit
null;
end;
/
exit
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |