Welsh Corgi (9/2/2014)

---

I changed the script to specify the actual Schema and Table Name.

It close but not quite there.

declare @cnt int,

@OracleRowCount int,

...

Time to walk away from another one. Sandbox, all I want is a sandbox.....

AARRRGGGGGGG!!!!!!!!!!! Someone fire the man. He has no business in this business.

Welsh Corgi (9/2/2014)

---

Thanks Lynn, you are awesome.

declare @cnt int,

@OracleRowCount int,

@OracleSchemaName nvarchar(max),

...

roryp 96873 (9/2/2014)

---

Lynn Pettis (9/2/2014)

---

I would have been, but the only notice I got was Saturday. Would have been nice to get one more notice on the day of...

Nope, I meant what I wrote; begininators. My term for the improper use of terminators at the beginning of statements. 😀

CELKO (9/2/2014)

---

You can ABSOLUTELY audit all changes (Insert, Update, Delete) in all databases and it not be against the law (aka Illegal). HOWEVER, it does not meet the...

I would have been, but the only notice I got was Saturday. Would have been nice to get one more notice on the day of the draft. I...

Eirikur Eiriksson (9/2/2014)

---

Further on the previous solution, here is an executable sample

😎

USE tempdb;

GO

;WITH BASE_DATA(NNAME,NGROUP) AS

(SELECT NNAME,NGROUP FROM (VALUES

('Bill','Finance')

,('Nancy','Ops')

...

I think I...

You'd think it was rocket science or something.

This work? You will need to the Parms piece from your code to this.

declare @cnt int,

@OracleRowCount int,

...

Ed Wagner (9/2/2014)

---

Thanks, but I guess...

Koen Verbeeck (9/2/2014)

---

Lynn Pettis (9/2/2014)

---

Am I missing something? Doesn't this error mean that the table or view doesn't exist, not that there is a problem with the WHERE clause?

OLE...

I don't have access to a an Oracle system so there is no way for me to try and sandbox this thing. Someone with access to a SQL Server...