DSXchange

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.please give me the help on this.

Regards
y.srini.

From the same list that you get DBMSCODE (the list of output link variables) choose LASTERR. This contains the error text.

No, it doesn't... or at least I haven't seen that returned anywhere from an OCI stage. Give it a shot and let us know. Typically I believe you will find that you have to farm that, post job, from the job logs.

Glad to be proven wrong!

It does from ODBC stage.

Another possibility would be to execute an oerr command to translate the code into text. Sometimes the text, with both explanation and recommendation, can be a tad long-winded however.