about Explain Plan

[MARC47MARC47]

I run the explain plan with select statement with cursor variable in SQL Window. The explain plan run the explan successful. However, I run the explain plan with delete statement with cursor variable. The explain plan can explain it.

I think it's because in select statement The SQL window change the cursor variable into a plsql developer variable, but no change in delete statement.

--==========select statement=============
SELECT COUNT(*)
INTO RA_APP_TRX_COUNT
FROM AR_RECEIVABLE_APPLICATIONS_ALL
WHERE APPLIED_CUSTOMER_TRX_ID = C1_REC.CUSTOMER_TRX_ID;
--=======================================

--==============delete statement===========
DELETE FROM AR_ADJUSTMENTS_ALL
WHERE ADJUSTMENT_ID = C1_REC.ADJUSTMENT_ID;
--==========================================

 

[Marco Kalter]

Automatic PL/SQL variable replacement is currently only supported for select statements. You will have to replace it by a bind variable manually.