Database Utilities (MOSC)

MOSC Banner

error during update

edited Mar 8, 2017 4:49AM in Database Utilities (MOSC) 3 commentsAnswered ✓

Hi,

while i try to update the dsn name it throws error

Error starting at line : 28 in command -

UPDATE sttm_branch set dsn_name ='jdbc/AFNAIB'

Error report -

SQL Error: ORA-06510: PL/SQL: unhandled user-defined exception

ORA-06512: at "AFNAIB.ELTR_STTM_BRANCH", line 84

ORA-04067: not executed, package body "AFNAIB.GLOBAL" does not exist

ORA-06508: PL/SQL: could not find program unit being called: "AFNAIB.GLOBAL"

ORA-04088: error during execution of trigger 'AFNAIB.ELTR_STTM_BRANCH'

06510. 00000 - "PL/SQL: unhandled user-defined exception"

*Cause: A user-defined exception was raised by PL/SQL code, but

  not handled.

*Action: Fix the problem causing the exception or write an exception

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center