how to capture Errordescription into ErrorTable

ysrini9 · Post by **ysrini9** » Fri Nov 04, 2005 4:03 am

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.

ray.wurlod · Post by **ray.wurlod** » Fri Nov 04, 2005 6:03 am

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

chulett · Post by **chulett** » Fri Nov 04, 2005 8:14 am

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!

ray.wurlod · Post by **ray.wurlod** » Fri Nov 04, 2005 3:21 pm

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.