ibatis에서 MSSQL OPENQUERY이용하기
ORACEL 접속을 링크드서버 쿼리문 SELECT TREEID, TREENM FROM OPENQUERY(CICHUB, 'SELECT CRSNM as treeId,CRSCD as treeNm FROM ECD_HRD_CRSMAS WHERE CRSCD = ''G2Z20020254'' ') 1. mssql 프로시저 생성 create proc sp_user3 @age varchar(50) as begin declare @str varchar(500) set @str= 'SELECT TREEID, TREENM FROM '+ 'OPENQUERY(CICHUB, ''SELECT CRSNM as treeId,CRSCD as treeNm FROM ECD_HRD_CRSMAS WHERE CRSCD = '''''+@age+'''..