Migrating From 4.5 To 5.0la While Setting Up Archive Triggers... Ora-06502 (Doc ID 550973.1)

Last updated on JULY 09, 2014

Applies to:

Oracle Transportation Management - Version: 5.0
Information in this document applies to any platform.

Goal

What is the Impact of the two errors seen when migrating from 4.5 to 5.0LA in the dbupdate_50a.sql
1). during the Setting up archive triggers...
ORA-06502: PL/SQL: numeric or value error
2). during the recompile of the invalid objects received the error
Errors for TRIGGER TG_ARCH_SHIPMENT:
10/2 PL/SQL: ORA-00936: missing expression

Does the <<NOTE 416073.1>> apply to the first error as well?

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