Oracle range limit AD BC dates

This is the extreme limit for oracle dates: alter session set nls_date_format = ‘Dy DD-Mon-YYYY AD’ ; select sysdate, to_date(’01-JAN-4712 BC’,’DD-MON-YYYY AD’), to_date(’30-DEC-9999 AD’,’DD-MON-YYYY AD’) from dual ; Without encountering this error: ORA-01841: (full) year must be between -4713 and +9999, and not be 0 01841. 00000 – “(full) year must be between -4713 and […]

Read More Oracle range limit AD BC dates
August 11, 2011

Oracle SQL Developer privileges for Other Users procedures and package bodies

To view code for procedures and package bodies in SQL Developer that are owned by other users, you need the following privilege: grant select_catalog_role to <user> ; This privilege does not give access to the sys.link$ view, so should be safe to grant out. You also need to use version 3 or above of Oracle […]

Read More Oracle SQL Developer privileges for Other Users procedures and package bodies
August 11, 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

2 Comments