SQL*Loader-00295: Warning: Table string, Column string - Quoting rule of object attribute bind variables has changed.

SQL*Loader-00295: Warning: Table string, Column string - Quoting rule of object attribute bind variables has changed.

Cause: The quoting rule of bind variables consisting of full object attribute names changed. The old quoting rule is incorrect because it can lead to ambiguous column references. For backward compatibility, current load will continue unless ambiguous column references are detected.

Action: This is only a warning message. Because the quoting rule of object attribute bind variables has changed, it is recommended that the control file be replaced with the new rule. With the new rule, a full object attribute bind variable name is not enclosed in its entirety in double quotes. Instead, each attribute name in the bind variable should be independently quoted as needed. Note that each attribute name is actually an identifier on its own and thus should follow the quoting rules for an identifier. For example, bind variable :A.B.C here consists of 3 attribute names (or identifiers): A , B , and C .

No comments:

Post a Comment