Re: Good editing environment....?

Kenn Herman wrote:

> The way I have been editting procedures is to have a scratch window to
>
> write my procedure in including the "create or replace" and the
> trailing "/". Once I am ready, I paste it into the sqlplus command
> line.
> well once there I can edit it with the editor of my choice, but as
> soon as
> I make any other SQL args then the buffer is lost. I have to then
> "select
> text from user_source where name = 'PROCEDURE_NAME';" to retrieve it
> and
> the paste it back to my scratch window.

Normally you have the sql script to create procedure(s) in a file. You edit the file with
any editor and run it in sqlplus as any script file. Received on Fri Jul 18 1997 - 00:00:00 CDT