More Ammo Against Dynamic SQL?
- From: Kellyn Pedersen <kjped1313@xxxxxxxxx>
- To: oracle Freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 23 Nov 2009 12:01:07 -0800 (PST)
I am working on a presentation to convince my company against some of the
dastardly dynamic SQL that we have in our code. We perform everything from
inserts, updates, deletes, selects and CTAS' all with dynamic SQL and it's
killing me!
I would love any new reasons NOT to use it, as I have all the standard reasons
like, inability to reuse sql in the buffer, parsing issues, bind peeking
issues, execution plan instability, etc..
Thanks for the assist! :)
Kellyn Pedersen
Multi-Platform DBA
I-Behavior Inc.
http://www.linkedin.com/in/kellynpedersen
"Go away before I replace you with a very small and efficient shell script..."
Other related posts:
