Skip to content

Set_Plsqlap_Environment

Sets server environment variables. The procedure stores the data in a table, PLSQLAP_ENVIRONMENT_TAB. Whenever a database session makes its first call to any function/procedure in the package the values stored in the table is used to set up the environment variables for the session.

The values for CONN_STR, USER and PASSWORD in the table PLSQLAP_ENVIRONMENT_TAB are loaded when an Middleware Server instance is created. These values must always be present in the table.

PROCEDURE Set_Plsqlap_Environment (   
   name_  IN VARCHAR2    DEFAULT NULL,  
   value_ IN VARCHAR2    DEFAULT NULL );

Parameters

name_
Environment variable name.

value_
Environment variable value.

Name Value Comment
CONN_STR http://<server>:<port>  
--- --- ---
USER IFSPLSQLAP  
--- --- ---
PASSWORD <password>  
--- --- ---
SSL_WALLET_PATH <path> for HTTPS support
--- --- ---
SSL_WALLET_PASSWORD <password> for HTTPS support
--- --- ---

Example

SQL> execute Plsqlap_Server_API.Set_Plsqlap_Environment('CONN_STR','http://jhmase0:59080');  

PL/SQL procedure successfully completed.  

SQL>