最近刚接触EBS,需要修改一个WEBADI,增加一列。接口的Package已经有预留字段了,但内容试图没有预留字段。在试图添加了所需字段后,在内容里并没有显示那一列。
执行以下语句:
DECLARE
v_col_name VARCHAR2(20) := 'XXX'; --内容列名称
v_coutent_name VARCHAR2(30) := 'XXX'; --内容名称
v_integrator_inner_name VARCHAR2(30) := 'XXX'; --集成器内部名称
v_rowid VARCHAR2(100);
v_recd BNE_CONTENT_COLS_B%ROWTYPE;
BEGIN
WITH content_cols AS(
SELECT ccb.*
FROM BNE_CONTENT_COLS_B ccb,
BNE_CONTENTS_B cb,
BNE_CONTENTS_TL ctl
WHERE ccb.CONTENT_CODE = cb.CONTENT_CODE
AND cb.CONTENT_CODE = ctl.CONTENT_CODE
AND ctl.LANGUAGE = 'ZHS'
AND ctl.USER_NAME = v_coutent_name
AND cb.INTEGRATOR_CODE LIKE v_integrator_inner_name || '%'
)
SELECT *
INTO v_recd
FROM content_cols
WHERE SEQUENCE_NUM = (SELECT MAX(SEQUENCE_NUM) FROM content_cols);
BNE_CONTENT_COLS_PKG.INSERT_ROW( X_ROWID => v_rowid,
X_APPLICATION_ID => v_recd.APPLICATION_ID,
X_CONTENT_CODE => v_recd.CONTENT_CODE,
X_SEQUENCE_NUM => v_recd.SEQUENCE_NUM+1,
X_OBJECT_VERSION_NUMBER => v_recd.OBJECT_VERSION_NUMBER,
X_COL_NAME => v_col_name,
X_USER_NAME => v_col_name,
X_CREATION_DATE => TRUNC(SYSDATE),
X_CREATED_BY => v_recd.CREATED_BY,
X_LAST_UPDATE_DATE => TRUNC(SYSDATE),
X_LAST_UPDATED_BY => v_recd.LAST_UPDATED_BY,
X_LAST_UPDATE_LOGIN => v_recd.LAST_UPDATE_LOGIN,
X_READ_ONLY_FLAG => v_recd.READ_ONLY_FLAG
);
COMMIT;
END;
在内容里已经显示了所加的列,OK!
执行以下语句:
DECLARE
v_col_name VARCHAR2(20) := 'XXX'; --内容列名称
v_coutent_name VARCHAR2(30) := 'XXX'; --内容名称
v_integrator_inner_name VARCHAR2(30) := 'XXX'; --集成器内部名称
v_rowid VARCHAR2(100);
v_recd BNE_CONTENT_COLS_B%ROWTYPE;
BEGIN
WITH content_cols AS(
SELECT ccb.*
FROM BNE_CONTENT_COLS_B ccb,
BNE_CONTENTS_B cb,
BNE_CONTENTS_TL ctl
WHERE ccb.CONTENT_CODE = cb.CONTENT_CODE
AND cb.CONTENT_CODE = ctl.CONTENT_CODE
AND ctl.LANGUAGE = 'ZHS'
AND ctl.USER_NAME = v_coutent_name
AND cb.INTEGRATOR_CODE LIKE v_integrator_inner_name || '%'
)
SELECT *
INTO v_recd
FROM content_cols
WHERE SEQUENCE_NUM = (SELECT MAX(SEQUENCE_NUM) FROM content_cols);
BNE_CONTENT_COLS_PKG.INSERT_ROW( X_ROWID => v_rowid,
X_APPLICATION_ID => v_recd.APPLICATION_ID,
X_CONTENT_CODE => v_recd.CONTENT_CODE,
X_SEQUENCE_NUM => v_recd.SEQUENCE_NUM+1,
X_OBJECT_VERSION_NUMBER => v_recd.OBJECT_VERSION_NUMBER,
X_COL_NAME => v_col_name,
X_USER_NAME => v_col_name,
X_CREATION_DATE => TRUNC(SYSDATE),
X_CREATED_BY => v_recd.CREATED_BY,
X_LAST_UPDATE_DATE => TRUNC(SYSDATE),
X_LAST_UPDATED_BY => v_recd.LAST_UPDATED_BY,
X_LAST_UPDATE_LOGIN => v_recd.LAST_UPDATE_LOGIN,
X_READ_ONLY_FLAG => v_recd.READ_ONLY_FLAG
);
COMMIT;
END;
在内容里已经显示了所加的列,OK!