We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Should we use Stored procedures

astro26
astro26 asked
on
Medium Priority
256 Views
Last Modified: 2010-04-01
I work for a medium sized company and was wondering about stored procedures.

Currently we create web apps using ColdFusion, at some point they may all be converted to Java Apps.  

Should we consider using stored procedures.  I do not think we will change the database (oracle 8i), but we could change our programming languages in the future.
Comment
Watch Question

Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Hi,

Stored procedures are the DB objects which are stored directly in the DB engine. It is better if you want to execute a long series of sqls depending on one anothers. As kennethxu told that if you change your DB it will be difficult to migrate (as if it rearly happen)

The crunch of the talk is that convert the SQL into SPs if there is a bundle of SQLs which are dependent on each other. Otherwise it is better to create dynamically SQL string and execute it against the DB. Practically you can never convert the each and very SQLs in SPs.
Thx

Author

Commented:
I use parameterized sql, from what I read... it seems as if SP's give you no preformance increase over parameterized sql.  I just thought that if I used sp's, then it would make it very easy to interchange programming languages.  The database will always be Oracle, so I do not think that will be an issue.
Thanks all!
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.