RE: SYSTEM.CURRENT_FIELD
Date: Tue, 22 Jun 1993 15:29:22 GMT
Message-ID: <1993Jun22.152922.25719_at_news.unomaha.edu>
I have since turned my question/problem over to Oracle due to the following
error messages.
PL/SQL error 903 at line 4, column 34:
The following KEY-ENTER trigger and procedure caused the error:
KEY-ENTER
bind variable 'global.temp_out' may not be an OUT parameter
:global.temp_date := substr(to_char(<block.field>),1,6) ;
convert_date (:global.temp_date, :global.temp_out) ;
<blah-blah>
else
<block.field> := sysdate ;
end if ;
PROCEDURE:
procedure convert_date (date_in in char, date_out out date) is
temp date;
begin
temp := to_date(date_in, 'MMDDYY') ;
date_out := temp ;
end ;
BTW ... Thanks for your suggestions and yes I know that I can use MMDDYY as the default but the sysdate format (DD-MON-YY) is prefered for displaying dates.
Mike. Received on Tue Jun 22 1993 - 17:29:22 CEST