Forms 6I oddity

From: guycorbett_at_my-deja.com <(guycorbett_at_my-deja.com)>
Date: 11 Feb 2002 06:27:39 -0800
Message-ID: <ad029fc8.0202110627.718cd37c_at_posting.google.com>



I am updating a forms application from Oracle 7/F45 to Oracle 9I/F6I. I cannot see why a piece of code which works ok in the old environment will not work in the new.
A form calls another using:

open_form(FmxName, ACTIVATE, SESSION, ParamListID);

The called form's WHEN-NEW-FORM-INSTANCE trigger calls a program unit whih has the code:

IF UPPER(name_in('PARAMETER.OPEN_ACTION')) = 'PASS_FK_QUERY' THEN

    IF name_in('PARAMETER.ENTRY_ID') IS NOT NULL THEN

      set_block_property('COMPOUND', DEFAULT_WHERE,
        'entry_id = ' || name_in('PARAMETER.ENTRY_ID') || 
        ' and delete_marked_date is null');
        message('g1');message('g1');
      go_block('COMPOUND');
        message('g2');message('g2');
      CheckPackageFailure;
      execute_query;

(Normally without the messages) On the first call message g1 is displayed and than the user is returned to the calling form, any subsequent calls work correctly. If a message is inserted in the calling form before the open_form the call works correctly every time. Has anyone got any suggestions as to what is going on? Received on Mon Feb 11 2002 - 15:27:39 CET

Original text of this message