• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 590
  • Last Modified:

Oracle 11g - Query error since Oracle SQL Developper version 4.0.3.16

Hi

I have thie below query that was working before with an older Oracle SQL DEV version, but since i have the new version 4.0.3.16, i get this error:

ORA-00911: invalid character
00911. 00000 -  "invalid character"
*Cause:    identifiers may not start with any ASCII character other than
           letters and numbers.  $#_ are also allowed after the first
           character.  Identifiers enclosed by doublequotes may contain
           any character other than a doublequote.  Alternative quotes
           (q'#...#') cannot use spaces, tabs, or carriage returns as
           delimiters.  For all other contexts, consult the SQL Language
           Reference Manual.
*Action:
Error at Line: 27 Column: 29

Do you know how i can fix this?

This error occurs when a special character is used in a SQL WHERE clause and the value is not enclosed in single quotations, but in my case, it is.

Thanks

SELECT LOAD_START_DATE_PERIOD,
  LOAD_START_DATE_YEAR,
  RATE_GROUP_ID,
  ORIGIN,
  DEST,
  BILL,
  LOAD_ID,
  LOAD_TYPE,
  TRIP_MODE_TYPE,
  CARRIER_ID,
  CARRIER_NAME,
  EQUIPMENT_TYPE_ID,
  NUM_STOPS,
  MILES,
  CUBE,
  WEIGHT,
  PCS,
  PALLETS,
  PLANNED_FUEL_ACCESS_COST,
  PLANNED_LINEHAUL_COST,
  PLANNED_TOTAL,
  PAID_FUEL_ACCESS_COST,
  PAID_LINEHAUL_COST,
  PAID_FUEL_ACCESS_COST ,
  PAID_LINEHAUL_COST
FROM TMMGR.TEMP_TRANS_FIN_ACT_RPT
WHERE LOAD_START_DATE_PERIOD = '1'
AND LOAD_START_DATE_YEAR     = '2015' 
AND STATUS                   = '70' ORDER  BY LOAD_START_DATE_PERIOD,
  LOAD_START_DATE_YEAR,
  RATE_GROUP_ID,
  bill;

Open in new window

0
Wilder1626
Asked:
Wilder1626
  • 3
  • 2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
please check (with a hexdump) if you don't have the character ascii #160 in the sql somewhere ...
it displays like a space, but it is not a space and will give exactly that error
0
 
Wilder1626Author Commented:
Hi

I,m not to much of a pro on SQL as i normally do basic SQL queries.

Can you please guide me on how i can check with hexdump?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
it has nothing to do with "sql", per se.

you put the sql "text" into a notepad, and open the file with a hexeditor (like Notepad++, ultraedit ...)
you will be able to see some "space" character that is ascii 160 ( hex code is A0 )
replace that with a regular space (ascii code 32, hex code is 20 ), and the sql should then run
0
 
Wilder1626Author Commented:
Funny thing happened. I rebooted my laptop and now, the same query works.
0
 
Wilder1626Author Commented:
Thanks again for your help.

always learning. :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now