Errors occur when you use statistical procedures with SAS/ACCESS® Interface to Oracle


Errors might occur when you use PROC FREQ, PROC MEANS, or other statistical procedures with SAS/ACCESS Interface to Oracle. The procedure completes, but then it gives an error along with an Oracle error. The following errors are examples of what you might see:

ERROR: Error during in-database processing.
ERROR: General error ORA-12154: TNS:could not resolve the connect identifier specified

The problem occurs if you are using a statistical procedure and your LIBNAME statement looks like the following:
 
libname x oracle user=xxx password=yyy path=”@zzz”;

To work around the issue, remove the @ sign from the PATH= option in your LIBNAME statement.