I'm assuming this is a limitation of the tools I use, but I am unable
to run a script for creating a trigger or stored procedure and have
the comments saved as part of the source. For example:

connect "db:db";

set term ^

create procedure Test
returns (a integer)
begin
/* This is a very important comment documenting the logic of this
SP */
a = 1;
end^
commit^


If I run this script, the results of the SP source would be:

create procedure Test
returns (a integer)
begin
a = 1;
end

The comment is considered a comment of the script, not of the stored
procedure.

Is there a script tool that will retain the comments in the source?

thank you,

Bob M..