Wilder1626
asked on
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
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;
ASKER
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Funny thing happened. I rebooted my laptop and now, the same query works.
ASKER
Thanks again for your help.
always learning. :)
always learning. :)
it displays like a space, but it is not a space and will give exactly that error