Update Statement

Hi,

I have an update statement within a procedure which is as follows: -

PROCEDURE CALLOUT_UPDATE (CALLOUT_PERIOD_ID_NEW VARCHAR2,
CALL_ID_NEW VARCHAR2,
CALLOUT_START_NEW VARCHAR2,
CALLOUT_END_NEW VARCHAR2,
RSN_RSN_ID_NEW VARCHAR2,
SOLUTION_NEW VARCHAR2,
COMMENTS_NEW VARCHAR2,
MILEAGE_NEW VARCHAR2,
HELPDESK_NUMBER_NEW VARCHAR2,
TIME_START_NEW VARCHAR2,
TIME_END_NEW VARCHAR2,
Original_CALLOUT_PERIOD_ID VARCHAR2,
Original_CALL_ID VARCHAR2,
Original_CALLOUT_START VARCHAR2,
Original_CALLOUT_END VARCHAR2,
Original_COMMENTS VARCHAR2,
Original_HELPDESK_NUMBER VARCHAR2,
Original_MILEAGE VARCHAR2,
Original_RSN_RSN_ID VARCHAR2,
Original_SOLUTION VARCHAR2,
Original_TIME_START VARCHAR2,
Original_TIME_END VARCHAR2) IS

BEGIN

UPDATE CALLOUT_DETAILS SET CALLOUT_PERIOD_ID = CALLOUT_PERIOD_ID_NEW,
CALL_ID = CALL_ID_NEW,
CALLOUT_START = CALLOUT_START_NEW,
CALLOUT_END = CALLOUT_END_NEW,
RSN_RSN_ID = RSN_RSN_ID_NEW,
SOLUTION = SOLUTION_NEW,
COMMENTS = COMMENTS_NEW,
MILEAGE = MILEAGE_NEW,
HELPDESK_NUMBER = HELPDESK_NUMBER_NEW,
TIME_START = TIME_START_NEW,
TIME_END = TIME_END_NEW WHERE
(CALLOUT_PERIOD_ID = Original_CALLOUT_PERIOD_ID) AND
(CALL_ID = Original_CALL_ID) AND
(CALLOUT_START = Original_CALLOUT_START) AND
(CALLOUT_END = Original_CALLOUT_END) AND
(COMMENTS = Original_COMMENTS) AND
(HELPDESK_NUMBER = Original_HELPDESK_NUMBER) AND
(MILEAGE = Original_MILEAGE) AND
(RSN_RSN_ID = Original_RSN_RSN_ID) AND
(SOLUTION = Original_SOLUTION) AND
(TIME_START = Original_TIME_START) AND
(TIME_END = Original_TIME_END);
COMMIT;


END CALLOUT_UPDATE;

If i execute this procedure using the following: -

exec Callout_Screen.CALLOUT_UPDATE('1', '21', 'd', '20050204', 'aaz', 'ghhdgd', 'hello','10', '2', '20', '10', '1','21','20050204', '20050204', 'aaz','ghhdgd','hello','10','2','20','10');

(the last 11 parameters are what is already stored in the database table and i have treble checked that these are 100% correct) when executed this completes successfully but does not actually update the row it should.

if i run the update statement on its own using the parameters above in the exec statement then it updates the row.

Can anyone see any silly mistake as i have been spending hours looking at this and i cannot see it.

Thanks!

See here