I ran into the same problem this week trying to expose 2 values from a table function for the current row.  I ended up converting the table function to 2 standard...

This trigger looks a bit like a conversion from Oracle with all the inherent pitfalls. Table Inserted includes all records stored by an after-statement trigger, not just a single row...

Applications quite often treat multi-row inserts as individual transaction. I split my triggers into 2 sections for @@rowcount=1 and @@rowcount >1.  In the latter I use a cursor which is...

You may not be able to control the mainframe, but you control the target side. You can write an instead-of trigger instead of insert (trigger action happens before the insert)  for...

If you do not apply the initial snapshot, then these sps are not created at the subscriber.  Every time a transaction at the publisher is replicated to the subscriber you'll...

Essentially I want to set up replication without initial snapshot synchronisation and I want to avoid having to create these replication sps at all using some MS supplied procedures. SQL...

M Chabot

No, I have not found the solution I was looking for.  Instead, I start the Identity with -2147483648.  I still can move to bigint if needed.

Win

I found another significant difference in trigger behaviour, which is not strictly due to different trigger implementation, but the way transactions are counted.

If @@trancount is used to find out if...

If I remember correctly TNS stands for Transparent Network Substrate.  An Oracle service name is associated with an Oracle database (instance).  You create a service name when you create a...

A blank char cannot be used in an oracle name.  The double-quote in oracle is similar to sql svr's square brackets.  If you create a table in oracle as TableName...

Are you looking for the equivalent of Oracle sqlplus commands define, prompt and accept?  These are only available in sqlplus - not in pl/sql.

T-sql is a poor cousing of  pl/sql...

One of your 3 parameters is a global (in out) parameter of a reference type - the equivalence of a cursor variable in sql svr  I don't know if you...

Without knowing what exactly is going on inside the oracle procedure it is hard to guess. For starters the error message could just be plain misleading.

If it is a procedure with a global...

Is your statement a pass-thru statment?  If so, have you tried to embed your statement in an Oracle pl/sql block:

begin pkg.spname(par1,pa2,par3); end;

Exec is a SQL*PLUS commmand, not a pl/slq command if...

Have you tried to enclose the parameters in brackets?

 exec pkg.spname(par1,par2,par3)

Cheers,

Win