This discussion is archived
1 Reply Latest reply: Jul 11, 2012 6:57 AM by CraigB RSS

Updating data based on procedure block

Oracle_81 Newbie
Currently Being Moderated
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;

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points