Renaming stored procedures

[Ruslan Zasukhin]

On 21/9/07 11:37 AM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:

> Hi List,
> 
> having stored procedures now, of course I want to rename them :-)
> 
> I see I can rename them I the schema editor. When I do this the
> procedure name changes in the column view, however the text of the
> procedure remains
> 
> create or replace spOldProcedureName()
> 
> At this point I wonder what needs to be done, so I copy the text of
> the (renamed) procedure to the SQLEditor and replace the
> spOldProcedureName() with spNewProcedureName()
> I execute the sql (no problem) and check the text of the renamed
> procedure. Still the old name in the text of the procedure  :-(
> 
> Having lived for a longer period with this women I quit and reopen
> VStudio and there you go : the text is updated with the new name.
> 
> So I think this means that in VStudio renaming of a Stored Procedure
> could do with a workover.

> Ideally it should adapt the text when the name property is modified.

right

> When that proves to complicated I think an sql command would be
> needed like:
> 
> rename procedure (oldname, newname)

Assume okay

> and renaming through the
> properties panel should be blocked (too confusing)

I have not catch Why?
 

> I did not use the refresh button because this crashes VStudio the
> whole time.

Then please send us such crash logs!
May be your db also. For us Refresh works.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]