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 Extended 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>/fndext/internalsoapgateway
USER	IFSPLSQLAP
PASSWORD	<password>
SHARED_SECRET	<shared secret string>	Not used in IFS Applikations7/7.5
SSL_WALLET_PATH		Https support - added by 59929
SSL_WALLET_PASSWORD		Https support - added by 59929
HTTP_PER_CONS	TRUE or FALSE	Socket utilization - added by 64444

Please look at bug 64444 for information on the HTTP_PER_CONS variable.

Example

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

PL/SQL procedure successfully completed.

SQL>