if (old.create_date is null) then new.create_date := sysdate; end if;This will fail because there are no old.xxxx values with an insert. I would need to test the new value.
if (new.create_date is null) then new.create_date := sysdate; end if;This version will work. Hope this helps.
Dig Deeper on Oracle Application Server
Related Q&A from John Garmany
We are using Oracle Database. In our client site, we have 500 users using the database at one time. Sometimes the database objects become invalid ... Continue Reading
I get the ORA-12541 error message when I try to connect through Forms6i and Reports6i Builder. I've started the listener. I have no problems ... Continue Reading
Initially Oracle 8i was installed on my PC. Recently I installed Oracle Forms 6i, and from that day on I was not able to connect to the database. It ... Continue Reading