Posts

Showing posts from April, 2013

Get All PLSQL Errors

I developed a function to get all PLSQL errors in schema.
This function should be used after calling program units so that can get PLSQL errors and you can use for logging and tracing.


Function Code

CREATE OR REPLACE FUNCTION GET_PLSQL_ERROS RETURN VARCHAR2 IS LC$RETVALUE VARCHAR2 (4000); CURSOR LCUR$ERRORS IS SELECT DISTINCT NAME, TYPE FROM USER_ERRORS ORDER BY 1, 2; PROCEDURE ADD_LINE (IN_LINE IN VARCHAR2) IS BEGIN LC$RETVALUE := SUBSTR (LC$RETVALUE || IN_LINE || CHR (10), 1, 4000); END ADD_LINE; BEGIN FOR LREC$ERRORS IN LCUR$ERRORS LOOP ADD_LINE (LREC$ERRORS.NAME || ' ' || LREC$ERRORS.TYPE); ADD_LINE ( RPAD ('-', LENGTH (LREC$ERRORS.NAME || LREC$ERRORS.TYPE) + 1, '-')); FOR LREC$ERROR_DET IN ( SELECT LINE, POSITION, SUBSTR (TEXT, 1, 128) TEXT FROM USER_ERRORS WHERE NAME = LREC$ERRORS.NAME AND TYPE = LREC$ERRORS.TYPE …

OAF : Get Current Row in Table

Sometimes you want to get current row in table. To apply this you can use the following code in controller and write it inside processFormRequest method.

    public void processFormRequest(OAPageContext pageContext,                                    OAWebBean webBean) {         super.processFormRequest(pageContext, webBean);         //Get application Module         OAApplicationModule am = pageContext.getApplicationModule(webBean);                 //Get Row Refrence         String rowReference =             pageContext.getParameter(EVENT_SOURCE_ROW_REFERENCE);                     //Get current Row using Row Reference            OARow currRow = (OARow)am.findRowByRef(rowReference);                 //Get attribute value from current row         String attrValue = (String)currRow.getAttribute("AttrName");     }

Thanks

Oracle OAF MDS Repository

MDS repository stores all pages and regions used in OAF pages and contain personalization and extensions.

All MDS data stores in the following 4 tables.
1. JDR_PATHS: Stores the path of the documents, OA Framework pages and their parent child relationship.
2. JDR_COMPONENTS: Stores components on documents and OA Framework pages.
3. JDR_ATTRIBUTES: Stores attributes of components on documents and OA Framework pages.
4. JDR_ATTRIBUTES_TRANS: Stores translated attribute values of document components or OA framework pages.

JDR_UTILS PL/SQL package supports the MDS repository and can be used to query and maintain the repository.

Thanks