SQL executed from memory as is
Hi,we have faced a need to sqls executed and store those in a table - and FGA should *not* be used.
I've done some mining and it seems that a table trigger might just do it using v$sql and v$sqlarea --> any insert etc done in sql does it right BUT when done through user interface in captuteres on bind variables, and
v$sql_bind_capture says "WAS_CAPTURED = NO"...
There must be a view etc or join where real sql can be captured, isn't there ??
Please any advice or example is highly appreciated,
BR,
timo
I've done some mining and it seems that a table trigger might just do it using v$sql and v$sqlarea --> any insert etc done in sql does it right BUT when done through user interface in captuteres on bind variables, and
v$sql_bind_capture says "WAS_CAPTURED = NO"...
There must be a view etc or join where real sql can be captured, isn't there ??
Please any advice or example is highly appreciated,
BR,
timo
0