DSXchange

Hi All,


Is there a way to get the Name of the Oracle Constraint which was violated during the load process?

Is there a way to get the oracle error message and not just the DBMS Code. (for example I get ora-0001, but i dont get the message Unique constraint violated)

Nagesh

Unfortunately, no - not from the reject link inside the job. The only place the full message exists is in the job's log. So you'd need to farm that information from there after the job completes.

If you don't want to roll your own, you might want to check out Mr Duke's ETLStats package you can download from his homepage. At the very least, he's already done most of the work for you... best case, all of it!

Ora 1 is primary key violation.

You can link the message constraint with the table to obtain more information.

But not and get the name of the constraint being violated.

Thanx Chulett and Sainath.