See value of bind variables

[Aljaz]


select
c.name, c.value_string
from
v$sqlarea a, v$sql_bind_capture c
where
a.sql_id = c.sql_id and
upper(a.sql_text) = 'SELECT DISTINCT MAX(MRT.MRNCODE) FROM MRNITEMS MRT,MATERIALRECEIPTNOTE MNS WHERE MRT.MRNCODE = MNS.MRNCODE AND MRNDATE = :b1 AND PURCHASEFWDDATE IS NOT NULL';