My Oracle Support Banner

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

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
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.