Help using Base SAS procedures

Assigning Oracle Library in SAS 9.2

Frequent Contributor
Posts: 78

Assigning Oracle Library in SAS 9.2

Hi People,

I am trying to assign a oracle library in SAS 9.2 something similar to this

libname mydblib oracle user=u317092 password=*** path='jdbcSmiley Surprisedracle:thin:@JEEPROD1:1526Smiley TongueRD0GIP';

however, my log came up with this error

7522 libname mydblib oracle user=u317092 password=XXXXX
7522! path='jdbcSmiley Surprisedracle:thin:@JEEPROD1:1526Smiley TongueRD0GIP';
ERROR: The ORACLE engine cannot be found.
ERROR: Error in the LIBNAME statement.

does anyone knows how to solve this?

thanks in advance! Cheers.
Super Contributor
Posts: 356

Re: Assigning Oracle Library in SAS 9.2

Have you got "SAS/Access to oracle" installed?
Ask a Question
Discussion stats
  • 1 reply
  • 2 in conversation