'델파이 인용'
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;
이렇게 했는데
'문장처리가 수행되지 않았습니다.' 라고 나옵니다
왜 그런건지 좀 갈켜주세요