OWB Process Flow With SQLPLUS Activity Fails With RPE-01038: Failed to evaluate expression (Doc ID 552144.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Warehouse Builder - Version 10.2 and later
Information 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
"GO_STO_GLO_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 "GO_STO_GLO_LOAD_STG"');end if;return
"SQLPLUS";end;begin :result := "GO_STO_GLO_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

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms