Error with SYSDATE in Forms 4.5.8

We need to get system date into two variables: Year and month in the first form of the application. How can we do that ?

We are trying to implement this piece of code

select to_char(sysdate, 'YYYY') into :conect.Year from dual;

At compile time works fine but at runtime generates the next error:

E40735: WHEN-NEW-FOR-INSTANCE: Trigger raised unhandled exception ORA-03114.

• when executing this instruction, it's giving me the following error:

Please send the answer to e-mails:
andrese_at_xenco.com
jaimeb_at_xenco.com
andresestrada_at_hotmail.com

XENCO Laboratories:
xenco_at_xenco.com Received on Sat Nov 08 1997 - 00:00:00 CET