Data is fetched into the below table entries using a cursor and when I display the table entries I can see the data to be populated correctly
@VTSAMPLETBL$MYTIMESTAMP,
@VTSAMPLETBL$LOT_NUMBER,
@VTSAMPLETBL$CONTAINER_NO,
@VTSAMPLETBL$PRPRTY_NAME,
@VTSAMPLETBL$UNITS,
@VTSAMPLETBL$RSLT_VALUE,
@VTSAMPLETBL$SEQ,
@VTSAMPLETBL$OFFSPEC_CHK
@VTSAMPLTBL is defined as collectionindexint OUTPUT and this field is being passed back to the calling procedure
The issue is the below statement does not the store the values onto @VTSAMPLETBL and hence the called procedure does not get the values passed to it
SET @VTSAMPLETBL = @VTSAMPLETBL.SetRecord(@J,@VTSAMPLETBL.GetOrCreateRecord(@J).AssignData(mig.fn_bulk_collect2Record(
(
SELECT
@VTSAMPLETBL$MYTIMESTAMP AS MYTIMESTAMP,
@VTSAMPLETBL$LOT_NUMBER AS LOT_NUMBER,
@VTSAMPLETBL$CONTAINER_NO AS CONTAINER_NO,
@VTSAMPLETBL$PRPRTY_NAME AS PRPRTY_NAME,
@VTSAMPLETBL$UNITS AS UNITS,
@VTSAMPLETBL$RSLT_VALUE AS RSLT_VALUE,
@VTSAMPLETBL$SEQ AS SEQ,
@VTSAMPLETBL$OFFSPEC_CHK AS OFFSPEC_CHK
FOR XML PATH
))))
Need expertise advise to fix this issue
Thanks in Advance!