Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Identifier too long

Status
Not open for further replies.

AyJayEL

Technical User
Jan 30, 2001
425
GB
I am using SQL Plus with Oracle 8.1.6

Can anyone tell me what this message means? -

ERROR:
ORA-00972: identifier is too long

Thank you. Learn something new every day *:->*
 
ORA-00972: identifier is too long
Cause: The name of a schema object exceeds 30 characters. Schema objects are tables, clusters, views, indexes, synonyms, tablespaces, and usernames.

Action: Shorten the name to 30 characters or less.

Alex
 
Alex

I can't find anything as long as 30 characters. Here is my SQL

select
rfr.open_date,rfr.reason,s.forename "Stud_F",
s.surname "Stud_S",cp.forename "cswrk_f",
cp.surname "cswrk_s",s.addressee "Addressee",
s.gender,s.ncy,cwlk.fullname, cwlk.email,
conp.surname "cont_surname", conp.forename "contact_forename",
ca.block_address "Cont_Address",
adlk.fullname "Admin_Fullname,
bases.base_name, sadd.block_address "Stud_Address",
decode(s.gender,'F', 'daughter', 'son' ) "son_daughter",
decode(s.gender, 'F', 'her', 'his') "his_her",decode(s.gender, 'F', 'her', 'him') "him_her",decode(s.gender, 'F', 'she', 'he') "he_she",sysdate + 14 "reply_by_14_days"
from
stud_contact sc,people conp,
corresp_address ca,corresp_address sadd,
sss_referrals rfr,student s,
student_lookup sl,people_lookup cwlk,
people_lookup adlk,people cp,bases bases

where
sc.contact_id = conp.person_id and
s.stud_id = sadd.entity_id and
sadd.c_corresp = 'C' and
conp.person_id = ca.entity_id and
rfr.stud_id = s.stud_id and
rfr.stud_id = sl.stud_id and
cp.person_id = cwlk.person_id and
rfr.case_work_id = cwlk.person_id and
rfr.admin_officer_id = adlk.person_id and
s.stud_id = al.entity_id and
s.base_id = bases.base_id(+) and
al.address_id = sadd.address_id and
al.c_corresp = 'C' Learn something new every day *:->*
 
You are probably getting zapped by missing quotes. You didn't end a quoted string properly, so Oracle continues to look for the close quote and eventually decides that your string is too long.

One missing quote is on the following line. I stopped looking, so there may be others:

adlk.fullname "Admin_Fullname,
 
You little star! Thank you. What a wally I am! Learn something new every day *:->*
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top