Error description capturing process

[ysrini9]

Hi

For rejecting rows purpose we are maintaining Errortable_log

in this table fields like Error_number,Errordescription,someotherfields.

here through linkvariable DBMSCode i am capturing Errornumber Ex:like

ORA-0091 like that but I have to capture error_description along with number like Uniquekey constraint vialation or primary key whatever Error number along with error description with out hardcoding.for finding the error description i am using lasterror or some constant i am using upto some limitation i am able to getting description(i would like to capture upto last point like uniquevilation or primarykey like that.please give me the help on this.

Regards
y.srini.

[chulett]

Why post this twice? Please see the answers in your previous version of this question.