Extract Oracle Ora-Error description

[willpeng]

Hey, just wondering if anyone tried to extract the Oracle ORA-? Description within a server job during insert/update. I know it's found in run Log, but anyone has tried to do it within the job itself?

The best I found it is the Code itself use the DBMSCODE in the Link Variable Outputs. But it is just the code, but no description as the warning in the log. Any idea??? Thx.

[chulett]

During the job that is generating the errors? No. Prefer to build jobs that don't generate errors. When they do, get the information from the log.

You'd need some kind of hook into 'oerr', perhaps a web service? Or pull a list from somewhere and populate a hashed file you could look up the description from. Seems like that would be pretty straight-forward to arrange.

[willpeng]

Hm... That gave me some idea. Thanks.

[ray.wurlod]

Investigate the link variable LASTERR. That is the error text generated by the database server (or by the ODBC driver, perhaps).

[sachin1]

link variable DBMSCODE. can help you, but regarding description of each oracle error is little tough.

[reddy.vinod]

Hey, just wondering if anyone tried to extract the Oracle ORA-? Description within a server job during insert/update. I know it's found in run Log, but anyone has tried to do it within the job itself?

The best I found it is the Code itself use the DBMSCODE in the Link Variable Outputs. But it is just the code, but no description as the warning in the log. Any idea??? Thx.

Hi,
You can capture the ORA error's .While loading the data into database table from transformer you simply take another link connect it to one seuential file ,take one column in sequential file next in the column derivation use DSGetLinkInfo(DSJ.ME,transformername,linkname,DSJ.LINKLASTERR)
bythe above method u can get the ora error's

[willpeng]

Thx, guys, I will check out the LastErr.

[chulett]

The OCI stage doesn't return the error description in any link variable that I recall. Perhaps with a 10g client? Or via ODBC?