3 Replies Latest reply on Jun 11, 2019 9:05 PM by jtracewell

    GRC Controls - Oracle Rule

    AB115

      Hello Experts,

       

      Need information on GRC Controls - Oracle Rule.

       

      Is there any limitation to edit the editor in GRC Controls - Form Rule?

       

      Thanks

        • 1. Re: GRC Controls - Oracle Rule
          jtracewell

          Hi,

           

          Can you clarify your question?  It is not clear what you mean by "is there any limitation to edit the editor"?

           

          When you edit an SQL rule in the editor, you need to re-compile the library.  (Concurrent request GRC Controls Generate Library.)  This regenerates the custom.pll with your new changes.

           

          Then, to test your changes, you need to start a new forms session so that the new library is loaded.

           

          The only limitation to editing SQL rules that I am aware of is that they must be 4000 characters or less.  The table where these are stored defines the column as such.

          If you attempt to add or copy/paste more than 4000 characters into the editor, the editor just doesn't _do_ anything.  No error, no message.  It just doesn't let you do it.

           

          Hope that helps.

           

          Jason

          1 person found this helpful
          • 2. Re: GRC Controls - Oracle Rule
            AB115

            thanks, it seems some limitation in it.

            • 3. Re: GRC Controls - Oracle Rule
              jtracewell

              Hi -

               

              If the limitation you're running up against is the 4000 character limit, we've hit that before to.

               

              We've done the following:

              * If it is a large select statement that is your main problem, create a view from the select statement and then use that view in your GRC rule code.

              * If it is some process then create a procedure in the database to do the process then call the procedure in your GRC rule code.

               

              Regards,
              Jason

              1 person found this helpful