Renaming stored procedures

[Bart Pietercil]

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.  
When that proves to complicated I think an sql command would be  
needed like:

rename procedure (oldname, newname) and renaming through the  
properties panel should be blocked (too confusing)

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

hth

Bart Pietercil