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.
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:
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.