1 Reply Latest reply: Aug 29, 2008 4:32 PM by Mark Striekwold RSS

    ORA-00000: normal, successful completion

    Tarek Fathy
      Dear all
      I'm using oracle designer version 10 release 2 with headstart.
      My form contains 3 block ,BROWSE,BUTTONS,and DATA
      In BROWSE block I execute query for all records.
      when press the button that display the detail of this record , the error ORA-00000: normal, successful completion and no data displayed

      my code is
      BEGIN
      :action_flag := RSK$block.one_rec(:switch,'RSK_DEFINE');
      If rsk$block.check_records(':browse.status',:action_flag,:switch,'RSK_DEFINE','D')>0 then
      qms$block.go('DATA');
      set_block_property('DATA',default_where,'V_INF.IND_ID='||:BROWSE.ID||')';
      qms$menu.set_current_action('EXECUTE_QUERY');
      execute_trigger('QMS$MENU_ITEM');
      END IF;
      END;

      Thanks in adnvance