I am working in SAS EG 5.1 using SAS 9.3. My project has several programs. At the start of some of the programs I clear the libname association because it may have been used in a previous submission. I then connect again because there is a timeout on our sessions.
I get the following error and would like to know how to address it. The statements following all run perfectly fine.
22 libname ora clear;
ERROR: ORACLE disconnect error: ORA-02396: exceeded maximum idle time, please connect again.
ERROR: Error in the LIBNAME statement.
23 libname ora ORACLE user="&ouser." orapw="&opassp." path="&opath_dw." schema="&ouser.";
NOTE: Libref ORA was successfully assigned as follows:
Engine: ORACLE
Physical Name: @tns:dwpr01-db
24 RUN;
Your previous ORA LIBNAME connection to Oracle has timed out because it has not been used within a time limit as defined in your Oracle database. Trying to clear a connection that has already dropped gives you the error.
The solution is to remove the LIBNAME CLEAR statement. There is no problem re-defining an Oracle LIBNAME even if it is still working.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.