Thank you, the lack of explicit conversation does seem to be the isssue.

I cannot use cast as the casting would have to be done on the Oracle side which...

The seems to be related to the way Oracle and SQLServer interact. If I query MyTable from Oracle I can see the column Id, so it is to do with...

Thanks Pablo, the development team on the SQL Server side didn't like this suggestion when I made it, but we've got round the problem by changing the column type. I...

I've also tried this with a second table with Id of type Bigint not null and everything works fine...It's definitely because it set to uniqueidentifier.

:ermm:

Changing the properties in SQLServer to default value of newid() and then removing "Id" from the Oracle procedure then compiles and suceeds, so pretty sure it is because it is...

I wish it was that simple. It's related to "Id" being set as a uniqueidentifier.

I mocked up the previous examples, here is the real thing....

USE [FirstClassUpgrades]

GO

/****** Object: Table [dbo].[MyTable] Script Date: 02/16/2010 12:37:19 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE...

That's correct.