Dynamic Procedure Created In Proport Execution Has Syntax Error PLS-00103: Encountered the symbol ">" (Doc ID 2051134.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Demand Management - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

Customer is on 12.2.4.1 and are executing the EBS_FULL_DOWNLOAD in Demantra, which automatically executes PROPORT, which generates a dynamic proc called DYN_PROPORT_SALES_1. This proc has a syntax error - Error(605,2): PLS-00103: Encountered the symbol ">" when expecting one of the following: ( begin case declare else elsif end exit for goto if loop mod null pragma raise return select update while with << continue close current delete fetch lock insert open rollback savepoint set sql execute commit forall merge pipe purge The symbol "return was inserted before ">" to continue.

Version_details_history

12.2.4 117 0 08-APR-15
12.2.4 1 UPGRADED FROM 29-OCT-14
12.2.4 117 0 29-OCT-14

db_exception_log

03-JUN-15 DYMANIC_DDL "-20002 ORA-20002: -20003 ORA-20003: Error in PROCEDURE EP_LOAD_MDP_LEVEL line 953
  executing dynamic_proc('proport('ma')') BEGIN EP_LOAD_MDP_LEVEL; END;"
03-JUN-15 EP_LOAD_MDP_LEVEL "-20003 ORA-20003: Error in PROCEDURE EP_LOAD_MDP_LEVEL line 953
  executing dynamic_proc('proport('ma')')"
03-JUN-15 DYMANIC_DDL "-20002 ORA-20002: -20003 ORA-20003: Error in PROCEDURE PROPORT line 764
  executing dynamic_proc('PROPORT_SALES(1)') BEGIN proport('ma'); END;"
03-JUN-15 PROPORT "*-20002*ORA-20002: -20003 ORA-20003: Error in PROCEDURE PROPORT line 764
  executing dynamic_proc('PROPORT_SALES(1)')"
03-JUN-15 DATA_LOAD "-20003 ORA-20003: Error in PACKAGE BODY DATA_LOAD line 4647
  executing ACTIVE_PROC_DYN('EP_LOAD_MDP_LEVEL')"
03-JUN-15 DYMANIC_DDL -24344 ORA-24344: success with compilation error BEGIN PROPORT_SALES(1); END;
03-JUN-15 PROPORT_SALES "ORA-06512: at "SYS.DBMS_SQL", line 1329
ORA-06512: at "DEMANTRA.SQL_ARRAY", line 304
ORA-06512: at "DEMANTRA.PROPORT_SALES", line 2842
"
03-JUN-15 PROPORT_SALES *-24344*ORA-24344: success with compilation error
03-JUN-15 PROPORT "-20003 ORA-20003: Error in PROCEDURE PROPORT line 764
  executing dynamic_proc('PROPORT_SALES(1)')"

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