Migrating From 4.5 To 5.0la While Setting Up Archive Triggers... Ora-06502

(Doc ID 550972.1)

Last updated on JULY 09, 2014

Applies to:

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


What is the impact of the two errors, when running dbupdate_50a.sql as part of migrating from 4.5 to 5.0LA.

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
10/2 PL/SQL: ORA-00936: missing expression

<> talks about the second error and that it can be ignored until run dbupdate_50b.sql
Does the same apaply for the first error as well?


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