Oracle OAF: Call Procedures and Functions

Call Procedure in OAF (1 input, 1 output parameter):            String sql = "BEGIN xx_custom_pkg.custom_prc (:1,:2); END;";             try {                OracleCallableStatement cs =                    (OracleCallableStatement)oam.getOADBTransaction().createCallableStatement(sql,                                                                                              2);                 ((OracleCallableStatement)cs.registerOutParameter(2,                                                                  Types.VARCHAR,                                                                  0, 2000));                 cs.setString(1, xxAttribute1Value);                cs.execute();               …

Continue ReadingOracle OAF: Call Procedures and Functions

Oracle OAF: Types of Controls and Types of CSS

(from Oracle Application Framework Developer's Guide 12.1.3)Some CSS Styles:OraDataText, OraFieldText, OraTipTextCommon Control Types:OAMessageCheckBoxBeanOAMessageChoiceBeanOAMessageDateFieldBeanOAMessageStyledTextBeanOAMessageTextInputBeanOAMessageLovInputBeanOther Control Types:OAInlineMessageBean, OAMessageAttachmentLinkBean, OAMessageBoxBean, OAMessageColorFieldBean, OAMessageDownloadBean, OAMessageFileUploadBean, OAMessageInlineAttachmentBean, OAMessageLayoutBean, OAMessageListBean, OAMessageLovChoiceBean, OAMessageLovTextInputBean, OAMessagePromptBean, OAMessageRadioButtonBean, OAMessageRadioGroupBean, OAMessageRichTextEditorBean, OARichTextEditorBean

Continue ReadingOracle OAF: Types of Controls and Types of CSS

Oracle OAF: Create a button on the fly

The following code requires you to setup a new custom message in Applications (Application Developer Responsibility) with name XXX_CUSTOM_MSG_BUTTON.OASubmitButtonBean oasb =    (OASubmitButtonBean)pageContext.getWebBeanFactory().createWebBean(pageContext,                                                                      "BUTTON_SUBMIT");oasb.setID("xxCustomButton");oasb.setUINodeName("xxCustomButton");oasb.setEvent("xxCustomButton"); String printTextMsg = pageContext.getMessage("XXX","XXX_CUSTOM_MSG_BUTTON",null);oasb.setText(printTextMsg);oawebbean.addIndexedChild(oasb);

Continue ReadingOracle OAF: Create a button on the fly

Oracle OAF: Session Information and Management

You can use the following snippets, for storing and getting values from the session:set session value:pageContext.putSessionValue("session_xxCode", xxCode_parameterString); get session value:pageContext.getSessionValue("session_xxCode")remove session value:pageContext.removeSessionValue("session_xxCode");Also through pageContext.getApplicationModule(webBean).getOADBTransaction() you can get a lot of session information.For example:pageContext.writeDiagnostics(this,…

Continue ReadingOracle OAF: Session Information and Management