Subject Maintainance of stored procedures
Author women_lover_best
Hi,
we have just completed our database design,and stored procedures
also.Now,there were some issues...some columns datatypee was required
to be changed..but Firebird is not allowing it as it says there are
dependencies due to stored procedures...so we have to drop all those
stored procedures..Our database team is worried it might become
difficult to maintain changes..to database and stored procedures..are
their some ways to handle such scenarios?
thks
vishy
P.S because of such problems..I dont like SP's...dynamicSQL using an
ORM tool is the way to go..