PL/SQL (MOSC)

MOSC Banner

ORA-00001 unique constraint (.) violated

in PL/SQL (MOSC) 7 commentsAnswered

Hi All

Kindly, I have a package with a select statement on a table from another DB using a DB link, most of the time the package is working fine, but in a few cases I am getting an error (ORA-00001 unique constraint (.) violated) in the select statement,

There is no DB trigger on the target table

  • My DB is: 11.2.0.4.0
  • Target DB which owns that table is: 11.2.0.4.0

In the trace file, I can see only this error and there is no ORA-00001 unique constraint (.) violated error in the trace file

-------------------------------

PARSE ERROR #36089306456:len=94 dep=2 uid=117 oct=3 lid=117 tim=1665940180846533 err=1

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