Re: [Q] How 2 automate stored procedure schema change?

In article <1995Jun26.142409.822_at_tron.bwi.wec.com>, MIZE.T.E_at_NORT.BWI.WEC.COM (TOM MIZE) says:
>
>Is there a way to automate the move of a stored procedure from one
>schema to another?

 [snip]
>Currently, I have to use sql*studio to export the code and then
>import the code and compile it under the CDAS schema. I do not want
>to give the developers the compile-any privilege.

Have a look at SQL*PAD from ObjectWorks, I have used it to migrate both stored procs and triggers from a development user in one instance to another user in another instance all by drag-and-drop.

>
>I would love to be able to have an automated way (stored proc for
>example) that would read the code out of the catalog and then
>recompile it under the CDAS schema.

I don't think there is a scripting language for the tool, but the simple drag-and-drop sure beats the tar out of exporting, ftp'ing, and recompiling manually. (I can select many at once to operate on).

You can get ahold of them at info_at_objectworks.com or (403)237-7333.

Hope this helps.
...Al Received on Mon Jul 03 1995 - 00:00:00 CEST