Paste in Command window

[Ivan C.]

Paste (Ctrl+V) in Command window doesn't work properly.
Here's how to reproduce it:
1. At the prompt start typing:

update emp

2. Hit the "Enter" key on the keyboard to get to the new line
3. Type

set ename =

don't hit "Enter"


4. Copy the text from below:

nvl (pkg_tool.f_valid_date
               (u.create_date, 'MM/DD/YYYY HH24:MI:SS')
           ,sysdate
           )

Note: I didn't try too many variations on this, so I used the string that my session failed with. Although I know that EMP table doesn't have the CREATE_DATE column, nor does SCOTT schema have the above mentioned package, I used this only for the purpose of reproducing the error.

5. Paste the content right after the "= " sign (line 2), from step 3.

Notice that the Command window now has two lines with number 2.

6. Type the "/" to execute the statement, and hit the "Enter" key.

I get the "ORA-00971: missing SET keyword" error.

It looks like line 2 was overriden by the Paste command. That was my assumption, after opening the command editor (ed).

Thanks.
IC

 

[Marco Kalter]

That is indeed not right. We'll fix it.