create_oracle_connection

create_oracle_connection function has 1 variants:

Variant 1

Description

1. create_oracle_connection creates a new named connection if it does not exist. If connection exists, does nothing.

2. If connection fails, create_oracle_connection returns error messages as character string.

3. This function can be called in any phase of execution, however it is advised to be called in "connection_not_found" trigger or in user login page.

Declaration

char create_oracle_connection(char connectionName, char tnsName, char userName, char userPassword);

Return Value

Nothing if connection has been made successfully. Otherwise, error text as string.

Parameters

char connectionName - unique name to identify this connection in web session

char tnsName - Oracle TNS Name

char userName - database login user name

char userPassword - database user password

Example

void connection_not_found(char connectionName) {
        char connResult;
        connResult = create_oracle_connection('default', 'XE', 'sys', 'password');
        /* or 
              connResult = create_oracle_connection('default', 'hello.world', 'sys', 'password');  
        */
}

void cb_oracle.logon2oracle() {
        char connResult;
        connResult = create_oracle_connection('default', :cb_oracle.tnsname, :cb_oracle.user, :cb_oracle.password);
        if (connResult is null) then
                show_page('oracle.frmx');
        else
                message('Error occured: ' || connResult);
        end if;
}
 
void cb_postgresql.logon2postgresql() {
    char connResult;
        connResult = create_postgresql_connection('default', :cb_postgresql.database, :cb_postgresql.user, :cb_postgresql.password);
    if (connResult is null) then
        show_page('postgresql.frmx');
        else
                message('Error occured: ' || connResult);
    end if;
}