1 Reply Latest reply: Jul 11, 2012 8:57 AM by CraigB RSS

    Updating data based on procedure block

    Oracle_81
      Hi,

      I have a block which is based on a procedure. This works fine by returning the results from the db. I need to update the data on the form and pass it to an update procedure on the data base. I have it working with a relativily simple

      PROCEDURE VOYAGE_LOG_UPDATE (p_result_set IN OUT t_log,
      p_logno IN VARCHAR2,
      p_rtc OUT INTEGER) IS
      BEGIN

      UPDATE TABLE A
      SET COUNTRY_CODE = 'ESP'
      WHERE log_no = p_logno;

      END;

      I require a few updates to a number of fields and was wondering that instead of passing each of the fields as prameters i could just assign the fields as there is only one row being returned on the oracle form....any ideas ? thanks


      UPDATE TABLE A
      SET COUNTRY_CODE = p_result_set(0).country_code
      WHERE log_no = p_logno;



      END PKG_UKFCC;