Announcement

Collapse
No announcement yet.

[ERROR] ORA-01741: illegal zero-length identifier

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Hayate
    started a topic [ERROR] ORA-01741: illegal zero-length identifier

    [ERROR] ORA-01741: illegal zero-length identifier

    When I export my query results into an excel file, I always get a 'ORA-01741: illegal zero-length identifier' error if my query have 'WHERE' conditions. Does anyone have any idea how to fix this issue?

    my query: select SERIAL_STT, TEN_SAN_PHAM, MA_SAN_PHAM, NGAY_HET_HAN, SERIAL_CODE, DON_GIA, DIEM_SO,TEN_SP from HOPTRI_CODE where ST='999'

  • mayho
    replied
    Hi Hayate,

    Cloud you please provide the following information for investigation? You can send the information to our Support Center - https://help.navicat.com/hc/en-us

    1. Your Navicat version, e.g. Navicat Premium (Windows) 11.2.8
    2. Your Server version. Oracle 10g
    3. The table sql with sample data. Right-click your table and choose Dump SQL File > Structure And Data.

    Leave a comment:

Working...
X