文档解释
ORA-25471: attribute name not specified for variable: string
Cause: An attempt to evaluate was made, which failed because one of the attribute values for the specified variable had a NULL attribute name.
Action: Check the list of attribute values, and try again with a valid attribute name.
ORA-25471：当程序调用 DBMS_SESSION.SET_IDENTIFIER() 函数，但没有指定变量名称时，会出现ORA-25471 错误。
官方解释
Cause: DBMS_SESSION.SET_IDENTIFIER call was made without the 2nd argument (the attribute name).
Action: Make sure the 2nd argument is specified to the DBMS_SESSION.SET_IDENTIFIER call.
常见案例
比如代码如下：
DECLARE
v_val1 VARCHAR2(100);
BEGIN
v_val1 := ‘value1’;
DBMS_SESSION.SET_IDENTIFIER(v_val1);
END;
调用了DBMS_SESSION.SET_IDENTIFIER()函数，但没有给它设置变量名，会导致ORA-25471错误。
一般处理方法及步骤
1. 修改程序代码，设置正确变量名。
例如修改上述代码为：
DECLARE
v_val1 VARCHAR2(100);
BEGIN
v_val1 := ‘value1’;
DBMS_SESSION.SET_IDENTIFIER(v_val1, ‘val1’);
END;
2. 重新编译程序，重新执行。
