ORA-06502 ORA-06512 when Running Soa_exec_interval_verify.sql (Doc ID 2193575.1)

Last updated on MARCH 07, 2017

Applies to:

Oracle SOA Suite - Version 12.1.3.0.0 and later
Information in this document applies to any platform.

Goal

ORA-06502 ORA-06512 Running soa_exec_interval_verify.sql 

When running the soa_exec_interval_verify.sql script, script exits with errors:

new 106: if 2 = 1 then
DECLARE
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: number precision too large
ORA-06512: at "SOAQ_SOAINFRA.VERIFY_BPEL", line 1290
ORA-06512: at "SOAQ_SOAINFRA.VERIFY_BPEL", line 1408
ORA-06512: at "SOAQ_SOAINFRA.VERIFY_SOA", line 198
ORA-06512: at "SOAQ_SOAINFRA.VERIFY_SOA", line 452
ORA-06512: at line 109

 

Solution

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