Identifier too long

[AyJayEL]

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 *:->*

 

[alexhu]

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

 

[AyJayEL]

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 *:->*

 

[karluk]

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,

 

[AyJayEL]

You little star! Thank you. What a wally I am! Learn something new every day *:->*