Oracle database Version - 12.2
Oracle Apex Version - 19.2
I Have a Ajax Call Pl/Sql Process in Page Level. and I have Created a javascript function to call apex.server_process Like Below
function SaveUser() {
apex.server.process("USER_CREATION", {
// p_clob_01:clob,
pageItems: "#P225_USER_CODE,#P225_USER_NAME,#P225_USER_TYPE,#P225_USER_DOB,#P225_MOBILE_NO,#P225_TELE_NO,#P225_EMAIL_ID,#P225_RESTRICT_FROM_DT,#P225_RESTRICT_TO_DT,#P225_PWD_DATE,#P225_FINGER,#P225_PASSWORD_EXP_DAY,#P225_ROLE_SCOPE,#P225_BRANCH,#P225_USER_ID" /*List of the items that are used in your process */
}, {
success: function(pData) {
if (pData.success === true) {
apex.message.showPageSuccess(pData.message);
} else {
apex.message.clearErrors();
apex.message.showErrors([{
type: "error",
location: "page",
message:pData.message,
unsafe: false
}]);
}
}
});
lSpinner$.remove();
}
}
Its Working Fine. But when I Submit the process It Save Data into Db. If I Submit again it Call the process with same Data. It Save the Session State Value.
How Can I Clear Session State and Clear Page without Submiting Page again for pl/sql clear Cache. Is the Any Javascript API For Clear Cache Page after call Apex.server_process.
Please help if you have any idea.