3 Replies Latest reply: Sep 23, 2013 2:48 AM by Dev. Musbah RSS

    How to return user parameter name and value?

    Dev. Musbah

      Hi All,

      I want to execute an auditing on the reports calling from forms.

      So I've used the After Parameter Form Trigger to save report name, user, and date of call in the DB and it works successfully (this is the master table)

      Now I've created a detail table to save the parameters names and values for each report called and saved in the master table mentioned.

      Is there any way to do that? I'm thinking of using functions returning parameters names and values if it exists (like Get_parameter_name for example)

       

      Note: I'm using Oracle DB 10g, Forms 6i and Reports 6i

      Thank you