ORA-00972 identitify is too long

[wuwangni06]

for v_ser in '(select a.nbr1,
a.nbr2,
a.dura,
a.date
from'||TABLENAME1||'a'||
'order by a.nbr1,
a.nbr2,
a.dura,
a.date)' ;
open v_ser for v_sql; --15行

这块代码15行报ORA-00972 identitify is too long
我定义的v_sql varchar2(4000); 大家帮看看什么问题啊

[jdsnhan]

Error: ORA-00972: identifier is too long
Cause: You tried to reference a table, cluster, view, index, synonym, tablespace, or username with a value that was longer than 30 characters.
Action: The options to resolve this Oracle error are:
Names for tables, clusters, views, indexes, synonyms, tablespaces, and usernames must be 30 characters or less. You must shorten the name to no more than 30 characters for these objects.

与 v_sql varchar2(4000) 是无关的。

[declare64]

把完整的语句贴出来了，这样好看错误

[mosaic]

估计TABLENAME代表的表明过长。

[codearts]

for v_ser in '(select a.nbr1,
a.nbr2,
a.dura,
a.date
from'||TABLENAME1||'a'||
'order by a.nbr1,
a.nbr2,
a.dura,
a.date)' ;

就这句错了, for 后面的in怎么会有引号呢？