Script Compilation Failed - Semantic Error around line nnn:Not all control paths lead to a return statement.

(Doc ID 1970438.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version 8.1.1.14 [IP2014] and later
Information in this document applies to any platform.

Symptoms

SIEBEL VERSION:
Siebel version : 8.1.1.14.2
Database version : Oracle 11.2.0.4
OS version : Windows 2012

ISSUE STATEMENT:
Customer has run Incremental Repository Merge (IRM) on IP2014 and tried to compile the full repository. Following error occurs :-

ERROR:
SBL-SCR-00125: Script compilation failed at line 5557307 in declarations section:
Syntax error at File "" Line 5557307 position 13:Invalid return statement. Return statement can't be used outside the function body.

SBL-SCR-00128: Script compilation failed at line 50 in procedure 'sortFilter':
Semantic Error around line 106:Not all control paths lead to a return statement.

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