|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
altering stored procedures as a batchis there a way to alter stored procedures as part of a batch? for
example if i want to change the name of a parameter, or field that appears in many stored procedures, is there a batch method i can use to essentially 'find and replace' the old value with the new value? thanks for any help, jason "jason" <iae***@yahoo.com> wrote in message Yes. Use EM to script all of the affected procedures. Then use a text news:1121440378.255739.129510@g49g2000cwa.googlegroups.com... > is there a way to alter stored procedures as part of a batch? for > example if i want to change the name of a parameter, or field that > appears in many stored procedures, is there a batch method i can use to > essentially 'find and replace' the old value with the new value? > editor to search and replace and otherwise fix up the script. Then run the script. David |
|||||||||||||||||||||||
Other interesting topics