Thanks. I must have changed it once and could not recall where it was.

Steve

I get OLE DB provider "OraOLEDB.Oracle" for linked server "CPS001T.DB.ATT.COM" returned message "ROW-00060: Internal error: [dainsert,16]?w?Ubl?H?°.

when attempting to insert > 20,000 rows from sql server 2005 to Oracle 10.2 using...

I have a problem that I cannot insert a row from sql server 2005 trigger to oracle 10.2 db.

I configured MS DTC correctly, because it works from a sql server...

Update:

I used sql server to sql server and the trigger works.

There is something about the Oracle/Solaris side that is missing or not right.

Something about needing a DTC equivalent on the...

Does anyone know what the registry settings should be for a 10.2 oracle client?

I seem to have old entries, possibly for oracle 8.

Steve

I followed those steps and still get an error:

Msg 7391, Level 16, State 2, Procedure TR_PMATT_PRJ_ID_INFORMATION, Line 15

The operation could not be performed because OLE DB provider "MSDAORA" for linked...

A developer asked me about this. He did not elaborate except to say there were user issues involved.

I don't think anyone should need to distinguish between one vs two...

I personally did not need to know.

A developer asked me to figure this out based on some user issues they had. He did not elaborate.

I don't think distinguishing between...

Good examples with varchar. Thanks.

Thanks for the replies. It makes sense that 1, 2, or 3 blanks is treated the same (with the entire column filled with blanks), but the empty string is...

Right, and I think I'll have to take that risk.

The worst that happens is I have to then ask for a reboot right away vs. waiting for a more convenient...

I am looking into what may have caused it. Some information is logged by a stored proc that looks for space increases and sends emails to alert me.

I just...

My tempdb, which hardly ever gets to over 10GB (almost all of it data), got to within 1 GB of the space limit on the drive it's on.

I wound up...

All valuable and fast replies.

Thanks guys!

I've used dynamic sql many times in Oracle, but it helps to see a t-sql example.

I implemented the event notification fo rlogin as in Frederick's article.

It work fine.

Now I want to only insert rows for certain loginname's.

I made another stored procedure with an IF statement...