Re: Binding DATEs in Forms 4.0
From: Steven P. Muench <smuench_at_oracle.com>
Date: Wed, 8 Dec 1993 00:17:05 GMT
Message-ID: <SMUENCH.93Dec7161705_at_doh.oracle.com>
Date: Wed, 8 Dec 1993 00:17:05 GMT
Message-ID: <SMUENCH.93Dec7161705_at_doh.oracle.com>
DOUG -- This is bug 172974, fixed in 4.0.12. Problem reproduces on
Windows if :BLOCK.DATEFIELD is referenced in SQL statement and the value of the field is non-Null. Workaround is to declare a local PL/SQL variable of type DATE, assign the forms field to the local PL/SQL variable, then reference the local DATE variable in the SQL statement. As mentioned previously, this is no longer an issue in 4.0.12.
-- Steve Muench Email: smuench_at_oracle.com Forms Development CIS: 73404,676 Product Manager Oracle CorporationReceived on Wed Dec 08 1993 - 01:17:05 CET