-- 대입할 파라미터를 정의
DECLARE @PARAM1 NVARCHAR (4000)
SET @PARAM1 = 'TEST'
DECLARE @ORACLE_QUERY NVARCHAR(4000)
SET @ORACLE_QUERY = 'SELECT Column1 FROM OPENQUERY(ORACLE_DB,''SELECT Column1 FROM DBNAME.ROUTING WHERE COLUMNNAME =''''' + @PARAM1 + ''''''')';
DECLARE @RESULT TABLE
(
RESULT VARCHAR(40)
)
INSERT @RESULT
-- OPENQUERY 실행
EXEC (@ORACLE_QUERY )
SELECT * FROM @RESULT