Change command delimiter?

srg

Has anyone else noticed the following behavior of the change command? Also, it appears as though the "/' entered on a line by itself does not only execute the contents of the buffer in the case of inputting a PLSQL block, but also appends the "/' character to the last line of the buffer....

SQLcl V4.2.0.16.131.1023

SQL> begin select * from dual; end;

  2  /

Error starting at line : 1 in command -

begin select * from dual; end;/

Error report -

ORA-06550: line 1, column 31:

PLS-00103: Encountered the symbol "/" The symbol "/" was ignored.

06550. 00000 -  "line %s, column %s:\n%s"

*Cause:    Usually a PL/SQL compilation error.

*Action:

SQL> l

  1* begin select * from dual; end;/

SQL> c.;/..

Error starting at line : 1 in command -

c.;/..

Error report -

Unknown Command

SQL> c!;/!!

Error starting at line : 1 in command -

c!;/!!

Error report -

Unknown Command

SQL> c/;/./

  1* begin select * from dual. end;/

SQL>

So it looks like the only acceptable delimiter is "/" though the SQL*Plus definition of the change command is:

C[HANGE] sepcharold [sepchar [new [sepchar]]]
Changes the first occurrence of the specified text on the current line in the buffer. The buffer has no command history list and does not record SQL*Plus commands.
Terms
sepchar
Represents any non-alphanumeric character such as "/" or "!". Use a sepchar that does not appear in old or new.

Thanks,

srg

thatJeffSmith-Oracle

Thanks, that's a bug on C[HANGE], will log!

thatJeffSmith-Oracle

Thanks, that's a bug on C[HANGE], will log!

srg

Thanks, Jeff. I appreciate you and your team's hard work on SD and SQLcl - they are great products that keep improving - a mark of your commitment and innovation, as well as a great user community!

-Steve