Category Archives: Oracle forms

unlock orcladmin password in shell script

Posted on 5 December 2011 by Andrew Fraser

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 … Continue reading →

Posted in Oracle forms, Scripts, Security | Leave a comment

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

Posted on 9 August 2011 by Andrew Fraser

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 … Continue reading →

Posted in Oracle forms | Leave a comment

Oracle Forms popup dialog alert box

Posted on 18 March 2011 by Andrew Fraser

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 … Continue reading →

Posted in Oracle forms | 1 Comment

Oracle Forms Dropdown List Item values populated from database table

Posted on 27 May 2010 by Andrew Fraser

Popup LOV boxes that retrieve their list from a database table are relatively easy to set up in oracle forms, the equivalent for a dropdown list item takes a bit more work. 1) First, create a new item in the … Continue reading →

Posted in Oracle forms | 5 Comments