Uncategorized

Initializing a connection from a connection poolInitializing a connection from a connection pool

Oracle may maintain state in a database connection that can cause difficult to diagnose problems. Packages may maintain state and context variables may be set. After obtaining a connection from a connection pool one should prepare the connection. An easy way to do this is to create the following procedure {...}