audit, bind variable question
840275May 17 2013 — edited May 20 2013Hi!
I want to audit the selects on a table, but i don't get all of the bind variables.
audit select on myschema.mytable by access;
The original select is HQL and the select converted to SQL in the AUD$ table looks like:
select...
where exists
(select id
from
myschema.mytable
where
mytable.mycolumn1=:4
and mytable.mycolumn2=:5)
mycolumn1 is VARCHAR2 (255 Char), mycolumn2 is TIMESTAMP(6)
In the AUD$ table I have the followign bind variables listed:
.... #4(24):myvalue #5(2):20 .....
Any date value i search for, there is the number 20 as a bind variable.
Why? How i can get the real date value?
Thanks in advance:
Bianca
Edited by: 837272 on 20-may-2013 0:46