RE: SYSTEM.CURRENT_FIELD

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:
  bind variable 'global.temp_out' may not be an OUT parameter

The following KEY-ENTER trigger and procedure caused the error:

KEY-ENTER
  if <block.field> is not null then
    :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