Q&A

  • 프로시저 어려운 문제
'델파이 인용'

With frmCallBatch_Run.Proc do begin

Close;

Prepare;

ParamByName('SELECTNAME').AsString := 'STATUS_BATCH_DELETE';

또는

Params[1].AsString := 'STATUS_BATCH_DELETE';

ExecProc;

end;



'오라클 프로시저'

여기서 패키지 호출

PROCEDURE BATCH_SELECT(TEC IN OUT BATCH_PACKAGE.RC, SELECTNAME VARCHAR2) IS



BEGIN

IF SELECTNAME = 'SCDR_SELECT' THEN

BATCH_PACKAGE.SCDR_SELECT(TEC);

END IF;

IF SELECTNAME = 'STATUS_SELECT' THEN

BATCH_PACKAGE.STATUS_SELECT(TEC);

END IF;

IF SELECTNAME = 'QINFO' THEN

BATCH_PACKAGE.QINFO_SELECT(TEC);

END IF;

IF SELECTNAME = 'STATUS_BATCH_DELETE' THEN

BATCH_PACKAGE.STATUS_BATCH_DELETE;

END IF;

END BATCH_SELECT;



패키지 부분

/* SCDR SELECT */

PROCEDURE SCDR_SELECT(TEC IN OUT RC) IS

BEGIN

OPEN TEC FOR

SELECT * FROM

SCDR;

END SCDR_SELECT;



이렇게 했는데

'문장처리가 수행되지 않았습니다.' 라고 나옵니다

왜 그런건지 좀 갈켜주세요

0  COMMENTS