My Oracle Support Banner

Auto Completion Does Not Correctly Place Cursor With SQLPROMPT Containing An Emoticon (Doc ID 2766147.1)

Last updated on APRIL 12, 2021

Applies to:

Oracle SQLcl - Version 20.3 and later
Linux x86-64

Symptoms

Disclaimer:

The example(s) provided are for demonstration purposes only and represents fictitious sample (based upon made up data used in the Oracle Demo instance). Any similarity to actual data, web sites and / or persons, living or dead, is purely coincidental and not intended in any manner.

Changing the SQL prompt of SQLcl with an emoji icons results in Auto completion of SQL statement placing the cursor in incorrect position.

Sample Java Script

Before Loading the emoticon, type "SEL" and press "TAB" for Auto completion of SQL statement. The cursor is placed after "SELECT".

After loading the javascript to include emoticon, type "SEL" and press "TAB" for Auto completion of SQL statement. The cursor is placed inbetween "SELECT".

Changes

 Use emoticon's in the SQL prompt.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.