unlock orcladmin password in shell script

Shell script to check if orcladmin account is locked, and unlock it if required # Check to see if orcladmin account is locked, and unlock it if it is. if [ “`ldapbind -p <myport> -D cn=orcladmin -w <myorcladminpassword>`” = “bind successful” ] then echo orcladmin account is ok, is not locked. else echo unlocking orcladmin […]

Read More unlock orcladmin password in shell script
December 5, 2011

Switch Oracle Forms List of Values on and off dynamically at run time

In e.g. post-query block level trigger: IF block.check_field = ‘F’ THEN — switch on Set_Item_Property( ‘block.field’ , LOV_NAME, ‘your lov’) ; Set_Item_Property( ‘block.field’, VALIDATE_FROM_LIST, PROPERTY_TRUE); ELSE — switch off Set_Item_Property( ‘block.field’ , LOV_NAME, ”) ; Set_Item_Property( ‘block.field’, VALIDATE_FROM_LIST, PROPERTY_FALSE); END IF ; H/t François Degrelle

Read More Switch Oracle Forms List of Values on and off dynamically at run time
August 9, 2011

3 Comments

Oracle Forms popup dialog alert box

Howto create a popup dialog box in Oracle Forms – called ‘alerts’ although can be used for all kinds of purposes, not just alerting. First create a new alert. Alerts are listed in the forms developer object navigator, immediately underneath Triggers. You can specify text and button names in the property palette of this new […]

Read More Oracle Forms popup dialog alert box
March 18, 2011

12 Comments