Posts by 'Ramandeep Singh' – Page 14

OPSS ADF Security Utility

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 …

Oracle Database account unlocker

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 …

Optimized update insert ADF ?

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 …

Error handling in adf

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 …

ora-01086: savepoint 'BO_SP' never established

If you are using ADF 11g and you encounter this issue kindly check your ps_txn table. You can delete the records from this table and then you will see that this error will go away. This table is used by ADFm internally to serialize user session state to database, so …