Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Bug Report: emoji bugs

Ming LeiJun 5 2017 — edited Oct 2 2017

Hi @"Hilary Farrell-Oracle" ,

Could you please help to log bugs related to emoji?

Recently, I found emoji might cause some weird bugs if I used them in my applications.

  1. emoji can not be saved in page designer after import

Steps:

  • Use emoji in the content of a static content region
  • then export
  • and then import the appllication to apex.oracle.com
  • then this emoji can not be changed any more in page designer

Error: when save, ORA-01426 prompt. This bug just exists on apex.oracle.com. Local ENV is ok to edit and update.

pastedImage_1.png

Workaround:

don't do this change in apex.oralce.com but in local Env. And then import again to the cloud.

  1. emoji cause import failed

Steps:

  • use emoji in THEME42, especially in navigation bar list (list name)
  • then export
  • and them import to local Env or apex.oracle.com (APEX 5.1.0 or 5.1.1)
  • import process failed

Error: PLS-00201: identifier 'WWV_OW_T_VARCHAR2' must be declared ORA-06550

Workaround:

From the error information, I guess the import procedure doesn't handle emoji, and emoji separates the normal string to cause WWV_FLOW_T_VARCHAR2 to be WWV_OW_T_VARCHAR2.

So remove emoji, import succeeds.

Thanks. Hope emoji bugs can be fixed soon.

B.R.

Ming

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 30 2017
Added on Jun 5 2017
#apex-discussions
6 comments
557 views