Need help with DATE and Forms 5.0

Details:

[Quoted]   Oracle 8.0.4 running on Solaris 2.6.
    init.ora has NLS_DATE_FORMAT as MM/DD/YYYY HH24:MI:SS

  Oracle Forms 5.0 (Developer/2000 R2.1)     Windoze98 Registry has NLS_DATE_FORMAT as MM/DD/YYYY HH24:MI:SS

[Quoted]   I have a table with a field of type DATE.

  In a PL/SQL library program unit I have a statement:

        val varchar2(20);

        val := name_in ( 'MYBLOCK.TIME_STAMP' );

This returns the date/time as:

        DD-MMM-YYYY note there is no time.

So...I try the following:

        val date;

        val := to_date ( name_in ( 'MYBLOCK.TIME_STAMP' ), 'MM/DD/YYYY [Quoted] HH24:MI:SS' );

I get the error ORA-06502 "PL/SQL: numeric or value error"

...so I try modifying the above call to:

        val := to_date ( name_in ( 'MYBLOCK.TIME_STAMP' ) );

...and I get the same error.

Would some kind soul point me in the right direciton. I need to get the value in MM/DD/YYYY HH24:MI:SS format.

I do have this format mask on the form field and the date/time does indeed display correctly on the form. I'm just not able to get that format with the built_in name_in function.

Much thanx! Received on Tue Sep 28 1999 - 15:37:32 CEST