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.
Extract Oracle Ora-Error description
Moderators: chulett, rschirm, roy
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 36
- Joined: Mon Jul 16, 2007 3:37 am
- Location: USA
Re: Extract Oracle Ora-Error description
Hi,willpeng wrote: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.
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
VINOD
Re: Extract Oracle Ora-Error description
Thx, guys, I will check out the LastErr.
William Peng
DW/ETL Consultant
Middletown, NJ
DW/ETL Consultant
Middletown, NJ