I am investigating how may I incorporate Oracle 11g's Client Result Cache (to prevent unnecessary trips to the database for some queries). In order to do so, a hint has to be applied to the SQL statement: /*+ RESULT_CACHE */

In the current release of version 2.5, what is the best way for me to incorporate this hint in the generated code?

Thanks

Arvinder Chopra

I think the following thread is relevant to your question, please check it out: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=11808