Migrating From 4.5 To 5.0la While Setting Up Archive Triggers... Ora-06502
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
Errors for TRIGGER TG_ARCH_SHIPMENT:
10/2 PL/SQL: ORA-00936: missing expression
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