title: Connecting to Oracle from SAS
body: <p>This how I configured my LibName    </p>
  
  <pre><code>LIBNAME OrcaleSAS ORACLE USER=UserName PASSWORD=pwd*** PATH = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host.unix.####.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=prod.tk.com)))'
  </code></pre>
  
  <p>And to fetch data below is the code I am using     </p>
  
  <pre><code>PROC SQL;
      connect using OracleSAS AS OracDB;
  select * from connection to oracle
  (select * from ENTITY_DATES_WK13);
  disconnect from OracDB;
  quit;
  </code></pre>
  
  <p>I am getting the error <strong>OracleSAS is not a SAS name &amp; Error in the LIBNAME statement</strong> , I am fairly new to SAS..!!</p>