개발 참고자료

CREATE PROCEDURE [dbo].[PR_RVAP_SEARCHADDRESS_] (
@as_clntnum VARCHAR (500),
@rs_errorCD VARCHAR (500),
@rs_errormsg VARCHAR (500)
)
AS
BEGIN
set @rs_errorCD = '8888';
set @rs_errormsg = '호출성공';

/* OUT과 상광없이 아래의 개수만큼 반환함... */
SELECT @rs_errorCD, @rs_errormsg

END
GO
/////////////////////////////////////////////////////////////////////////////////////////////////////////
파워빌더 소스영역

ls_sql ='EXECUTE PR_RVAP_SEARCHADDRESS ?, ?, ?'
DECLARE CUR1 DYNAMIC PROCEDURE FOR SQLSA ;
PREPARE SQLSA FROM :ls_sql USING sqlca;

sTemp = " "
s_errorMsg = " "

EXECUTE DYNAMIC CUR1 USING :s_clntNum, :sTemp, :s_errorMsg ;

if sqlca.sqlcode <> 0 then
rs_errormsg = sqlca.sqlErrText
Rollback using sqlca;
end if

FETCH CUR1 INTO :sTemp, :s_errorMsg ;

if sqlca.sqlCode = 0 then
else

s_errorCd = "-99999"
s_errorMsg = sqlca.SqlErrText
end if

CLOSE CUR1 ;