1 Reply Latest reply on Jan 7, 2014 9:11 AM by Christian Erlinger

    Any disadvantage of using EXEC_SQL in Forms

    864019

      Hi All,

       

      In our application we are using EXEC_SQL for dynamic cursor in multiple places. Do we have any disadvantages in using EXEC_SQL???


      Thanks,

      maddy

        • 1. Re: Any disadvantage of using EXEC_SQL in Forms
          Christian Erlinger

          Besides that it is incredibly slow and has a bug in a11g Version (11.1.2.0 or so I think; fixed in the latest 11g patchset, and also doesn't occur in 10g and lower) so you can't submit querys longer than 1024 characters there is no drawback. Oh, yes, in multibyte environments be aware that +define_column+ accepts the length of a varchar2 variable in BYTES; which means you'll have to pass the maximum BYTE length of a varchar2 variable when retrieving multibyte characters from the database.

           

          cheers

          1 person found this helpful