how get OraOLEDB.Oracle messages from sql server

797740

Hi,

I am trying of get the oracle exception messages for linked server in sql server. With ERROR_MESSAGE() I get a generic error. How I can get the oracle errror with 'ORA-001' format ?
thanks

997028

If understand you right this should do the job:

try
{
// do some Oracle database stuff here
}
catch(OracleException exc)
{
String error = exc.Message;
}

This always gives me the errors with the format you wanted.

I hope I got you right and that it helps you.

Best regards,
Matthias

797740

your code is correct but in C#. I am using T-SQL with linked server.

Pd. Already is Active the MSDTC in the SQL SERVER