Re: Need help with DATE and Forms 5.0
From: Jason Pepper <jpepper_at_uk.oracle.com>
Date: Tue, 28 Sep 1999 14:47:22 +0100
Message-ID: <7sqi08$7ac$1_at_inet16.us.oracle.com>
Date: Tue, 28 Sep 1999 14:47:22 +0100
Message-ID: <7sqi08$7ac$1_at_inet16.us.oracle.com>
This is a restriction of NAME_IN.
You will need to do some explicit date conversion types when working with NAME_IN Check the restrictions on NAME_IN in the Developer on line help.
-- regards Jason ---------------------------------------------------------------------------- Jason Pepper Snr Product Manager Enterprise Internet Tools Oracle Corporation Jim West <Jim.West_at_mci.com> wrote in message news:ocLwN2my0fGSXKN0=sbinj=x=B7L_at_4ax.com...Received on Tue Sep 28 1999 - 15:47:22 CEST
> Ok, I'm stumped on this one.
>
> Details:
>
> 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
>
> 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
> 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!
>
>