User Application Enqueue

To update a row and change the ticker AMZN to QCOM and also change the other columns’ values, use the following SQL block:

DECLARE
  newunit1        SYS.LCR$_ROW_UNIT;
  newunit2        SYS.LCR$_ROW_UNIT;
  newunit3        SYS.LCR$_ROW_UNIT;
  newunit4        SYS.LCR$_ROW_UNIT;
  new_vals        SYS.LCR$_ROW_LIST;
  old_vals        SYS.LCR$_ROW_LIST;

BEGIN
newunit1 := SYS.LCR$_ROW_UNIT( 'TICKER',   
  SYS.AnyData.ConvertVarchar2('AMZN'),
  DBMS_LCR.NOT_A_LOB, NULL, NULL)

newunit2 := SYS.LCR$_ROW_UNIT( 'OPEN_PX',  SYS.AnyData.ConvertNumbe
(40.45), DBMS_LCR.NOT_A_LOB, NULL, NULL);

newunit3 := SYS.LCR$_ROW_UNIT( 'CLOSE_PX', SYS.AnyData.ConvertNumbe
(40.90), DBMS_LCR.NOT_A_LOB, NULL, NULL);

newunit4 := SYS.LCR$_ROW_UNIT( 'PX_DATE',  SYS.AnyData.Convertdate( trun
(sysdate) ), DBMS_LCR.NOT_A_LOB, NULL, NULL);

old_vals := SYS.LCR$_ROW_LIST(newunit1, newunit2, newunit3, newunit4);