Toad World® Forums

Small Bug in SQL plan against PLSQL code when using array binds

Hi

Toad 12.9.0.3 x64.

Write a code in PLSQL code where binds are bulk array values.

DELETE SERVICE_FEATURE
WHERE BAN=sf_arr(i).BAN
AND SUBSCRIBER_NO=sf_arr(i).SUBSCRIBER_NO
AND SOC=sf_arr(i).SOC
AND SOC_SEQ_NO=sf_arr(i).SOC_SEQ_NO
AND FTR_SOC_VER_NO=sf_arr(i).FTR_SOC_VER_NO
AND SERVICE_FTR_SEQ_NO=sf_arr(i).SERVICE_FTR_SEQ_NO

Select that code and click on “Explain plan current statement”. Toad open a popup and shows code whish has replaced values but last letters are not in commented part:

Brg

Damir