-------------------------------------------------------
--  what : stmtbvar.sql 
--  when : 24-MAY-2006
--   why : This little script captures the values of 
--         the bind variables for a SQL statement.
-- where : 
--   how : 
--   who : David Clement
--   fix :
-----------------------------------------------------------

select distinct hash_value,
  name,
  value_string
from v$sql_bind_capture
where sql_id = '&sql_id'
/