A script-enabled browser is required for this page to function properly.

EXEC_SQL.Valid_Connection

Description

This functions checks whether a connection is valid or not. When Connid is not specified, the default connection that is stored in the cache is used.

Syntax

FUNCTION VALID_CONNECTION(Connid IN ConnType) RETURN BOOLEAN;
FUNCTION VALID_CONNECTION RETURN BOOLEAN;

where:

Connid is a record of ConnType

Return Type: BOOLEAN
TRUE if the specified connection is valid (non-null), FALSE otherwise.

Example

bool_flag := exec_sql.valid_connection( myconnid );