5

So I just got an insight from my PW session in SQLplus. I finally understood why the fridge did the SQL console under Oracle return the error:
ORA-00911: invalid character
on a line that seemed perfectly correct, but it's as if it spawned you an invalid character, just because.
But in fact, when I enter a character unintentionally like ç, then I remove it, it's as if the text prompt makes it look like it got removed, but there's still the cedilla, or at least its character code roaming around in the line I'm writing, and thus resulting in an error.

I'm not even salty now, that got me curious, and I think it's better like this, even if I'll require a bit of research on that thing later on.

Comments
  • 0
    Wow. What version is your sqlplus? Windows install?

    I've never come across any console input buffering issues. That's interesting :)
  • 0
    @netikras I haven't paid attention to the version name or number. But it's likely an outdated one, because it is hosted on my university's server which runs under the OS Ubuntu 16.04. Dunno if it matters much to the app version actually, but I don't believe it's the latest version.
  • 0
    @KuroTenshi67 16 ubuntu... Umm... Oracle 11g?
  • 0
    @netikras Oracle, yep. But then again, didn't take note of the Oracle version.
Add Comment