Blog Archives

TalkingByte Thinforms: Oracle Forms on iPad, Android and PCs without JRE

Oracle Forms on iPad, Android and PCs without thick client Java Runtime Environment download. www.talkingbyte.com/?p=2

Posted in Oracle forms

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

Posted in Oracle forms, Scripts, Security

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

Posted in Oracle forms

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

Posted in Oracle forms

Oracle Forms Dropdown List Item values populated from database table

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

Posted in Oracle forms