Wednesday, June 03, 2009

ORA-01741: illegal zero-length identifier

Always check out the original article at for latest comments, fixes and updates.

This is another curious error message that i presume is rare to be seen twice in your life.
alter session set tracefile_identifier="";

ORA-01741: illegal zero-length identifier
Oracle accepts the double quotes as string delimiter, but not when there is nothing in between.
In fact it is perfectly possible to execute:
alter session set tracefile_identifier="xyz";

select value
from v$parameter
where name = 'tracefile_identifier';


In order to set the session parameter to a null value, single quotes must be used:
alter session set tracefile_identifier='';
Note also that ALTER SESSION, unlike ALTER SYSTEM, doesn't come with an ALTER...RESET... clause.

See message translations for ORA-01741 and search additional resources.

No comments:

yes you can!

Two great ways to help us out with a minimal effort. Click on the Google Plus +1 button above or...
We appreciate your support!

latest articles