Re: mixing dynamic native sql and static sql?

From: Peter Mutsaers <plm_at_gmx.li>
Date: 19 Apr 2002 18:56:07 +0200
Message-ID: <ulmbjzkyg.fsf@plm.gmx.li>

>> On 12 Apr 2002 07:02:15 -0700, Thomas Kyte <tkyte_at_oracle.com> said:

TK> if the order by is dynamic -- the entire query is. You can TK> use the technique outlined on:

TK> http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:1288401763279

Thanks a lot. I'm now using this sys_context technique with great success, an enormous improvement to only binding with 'using' in this case.

Funny that the oracle manual only presents sys_context as a means to control access, and not as a 'general purpose' dynamic binding technique.

I'm now moving lots of dynamic SQL queries that formerly was generated in Java (without any binding) into PL/SQL procedures that use this. Received on Fri Apr 19 2002 - 11:56:07 CDT