Database Security Products (MOSC)

MOSC Banner

I want to generate sql statement by using columns lsqltext and lsqlbind of table sys.fga_log$ while

I want to generate sql statement by using columns lsqltext and lsqlbind of table sys.fga_log$ while audit trail is DBMS_FGA.DB + DBMS_FGA.EXTENDED . I actually generate sql statements by replacing bind variables used in lsqltext with the values of bind variables in lsqlbind columns. Problem is that LSQL Text column records sql text in different ways some time it generates text like

insert into emp (id,name) values (:1,:2)

and some it generates record like

insert into emp (id,name) values (:"SYS_B_0",:"SYS_B_1") . issue is that in which case it records sql text like "SYS_B_0" ,"SYS_B_1"

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center