Knowledge Article View - Customer Support

Using the LIBNAME engine with SAS/ACCESS^® Interface to Oracle with one of the following procedures might result in an error:

PROC MEANS/SUMMARY
PROC FREQ
PROC REPORT
PROC TABULATE
PROC RANK

The error, shown below, occurs when the DBINDEX=YES option is included in the LIBNAME statement. Rather than the majority of the processing being done within Oracle, SAS retrieves the rows from the table and processes the procedure itself. This might result in a performance issue.

ERROR: Requested function is not supported.

Currently, the only workaround is to remove the DBINDEX=YES option from the LIBNAME statement.

Using the option DBINDEX=YES in an Oracle LIBNAME statement turns off in-database processing of BASE SAS® procedures