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>