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>