Hi All,

I'm trying to create a trigger that when someone attempts to insert a new record, the trigger changes the date using to_date to allow a date/time combination to be entered.

The problem is that my users are connecting to the database using a JDBC connection so the trigger can only be at the database layer.

I'm sure this is possible but after looking at pl/sql error messages for the last 12 hours, perhaps I'm wrong...