There is a caveat i wanted to highlight with respect to view criteria that has a performance impact. if you use a view criteria it is applied after the query block as shown below. This example is based on the scott schema.

1

select * from (select empno from emp)QRSLT …

In this post i am sharing a utility for performing the following operations on OID using the OPSS API :-

1. User creation
2. Dropping a user
3. Getting all roles for a user
4. Role/Roles assignment to user/users
5. Revocation of role/roles from user/ users
6. Changing password for a user
7. Resetting password …

This is a simple procedure i created for unlocking user account and resetting the password to the original password, Although a very small utility it helps you with unlocking accounts that you tend to use after a long time which in my case were the SOA server and the BAM …

I had a recently asked a question on bulk uploads in OTN forum. Seems the performance that i would receive for bulk update/insert scenarios isn't at par. So i created the procedure and a custom object type and table of that object type which provides far better performance. Let's …

To override the default error handler one can extend the DCErrorHandlerImpl. In this you can process the exceptions or can choose to suppress them. In this post i will explain a way to suppress the RowValException message and display only the detail entity attribute level exception ie AttrValException. In ADF …