hello fellow SAS-users, we are trying to "check" for an "active" ACCESS to oracle connection (which is set via libname at the start of the process). The connection is working most of the times, but as the oracle instance is setup in a way that there is a limited number of "licenses" that have concurrent access to the database, we are running into some problems during heavy load times. Is there an intelligent way to check for "active" connection to the oracle instance, besides trying to "load data" (data step, pass through) and checking for error codings? Is there some meta-information about the current status of the library/connection? thanks in advance for any helpful insights!
... View more