Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Server 2000 to Oracle 9i -- SP_EXECUTESQL

448803Aug 4 2005 — edited Oct 27 2005

What is the besst way to translate the following SQL Server statements?

SET @exec = 'SELECT @exist = ' + quotename(@Index_Name) + ' FROM ' + quotename(@Table_Name) +
' WHERE ' + quotename(@Index_Name) + ' = @Record_Index '
EXEC sp_executesql @exec, N'@exist [int] OUTPUT, @Record_Index [int]',
@exist OUTPUT, @Record_Index = @Record_Index

Is there a comparable construct for Oracle?

Thanks,
Chris

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 24 2005

Added on Aug 4 2005

#database-and-application-migrations

5 comments

1,064 views