Test for rows on linked Oracle server from SQL Server

Question

I get a syntax error with this TSQL:

if exists ( exec('select * from mytable') at LinkedOracleServer ) begin
    print 'rows exist'
end

I can't use INSERT EXEC into a temp table because the calling proc also uses INSERT EXEC and I get the error "An INSERT EXEC statement cannot be nested."

Is there another way to test for existing rows on a linked server?

Pradeeshnarayan · Accepted Answer · 2012-09-12 11:09:56Z

1

It is just a suggestion. Can't you try like this

select @recod_count = count(*) from LinkedOracleServer.mytable
if @recod_count>1 begin
end

answered Sep 12, 2012 at 11:09

Pradeeshnarayan

1,23510 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Test for rows on linked Oracle server from SQL Server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related