2 Replies Latest reply on Feb 28, 2020 3:45 PM by Sanal Krishnan Narayanan

    User Defined Reports - bind variable - does not ask for value on run

    Sanal Krishnan Narayanan

      Oracle SQL Developer


      Build 354.1759


      Created a User Defined Reports for the below query :

      select username, userhost,timestamp,action,action_name,LOGOFF_TIME,RETURNCODE,SESSIONID
      from dba_audit_trail d
      where d.username =upper(':my_userid')
      and timestamp >= sysdate -3
      order by timestamp desc


      On running the report, it does not ask for value for the bind variable and shows a table view with no rows