You don't need stored proccedures at all if you want to ...

My group owns 50 plus J2EE projects (Oracle 10g),and all of them need database. Only one project uses stored procedures because it was written by an Java programmer & a DBA. All other projects have none because they were developed by pure Java programmers. By the way, a lot of projects are very big.

Stored procedures have their places, but they are not always desirable. Now, I own the project with a lot of SPs. Debugging it is not easy because I have to find out the problem was caused by Java code or by SPs.

Also, due to our company policy, any development group doesn't own database any schemas on any production database servers, so we can't modify SPs. We have to send request to DBA which takes at least one week.

所有跟帖： 

• i assume u don't have access to datatable, right? -撅著挺好- ♂ (238 bytes) () 10/18/2009 postreply 01:13:56

• 這也太高深了。一點兒都不user friendly. 我有access to -小謀- ♀ (32 bytes) () 10/18/2009 postreply 06:49:07

• Why use database at all if you don't access table... -oneusdollar- ♂ (1873 bytes) () 10/18/2009 postreply 10:44:27

• excellent point, thank you for sharing! -HappyNow?!- ♂ (0 bytes) () 10/18/2009 postreply 10:54:38

• r u talking about BEST practice? -撅著挺好- ♂ (1698 bytes) () 10/18/2009 postreply 16:00:07

• accessing data table means access its schame.... -撅著挺好- ♂ (72 bytes) () 10/18/2009 postreply 17:07:37

• 回複：accessing data table means access its schame.... -海闊天空33- ♀ (708 bytes) () 10/18/2009 postreply 20:03:46

• The worst thing in industry is.... -撅著挺好- ♂ (783 bytes) () 10/18/2009 postreply 21:20:36

• I had the same feeling: the old day was the -HappyNow?!- ♂ (44 bytes) () 10/19/2009 postreply 10:42:04