I connect to a DB, open a new Edit SQL window to alter a stored procedure.
I type - ALTER PROCEDURE and code completion propose me a list of SP.
I select the one that I want change and press enter.
At this point in Edit SQL appear :
ALTER PROCEDURE <SP_NAME> @param1, @param2, …@param-n .
Why this ? I don’t understand how code completion works.
If I want to alter/change a stored procedure, probably it’s better if when I type ALTER PROCEDURE code completion insert/copy all the sql statement of the stored procedure, not only the parameters.
If in the editor SQL appear all code of SP now I can alter or change it without problem.
If I see only declaration of alter procedure and relative name and parameters how can I alter it ?
I must open stored procedure declaration in another window, see it and at this point return to my first Windows and alter it.
I know that there is a possibility to alter stored procedure via Object Explorer, but someone I prefer works in Editor SQL directly.
Same behavior in Toad Xpert 6.5 edition.
I stay tune for your consideration,