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

EXEC_SQL.IS_OCA_CONNECTION built-in function

This procedure returns TRUE if a specified connection handle is for an OCA connection.

Syntax


FUNCTION EXEC_SQL.IS_OCA_CONNECTION
([connid IN CONNTYPE]
RETURN BOOLEAN;

Parameter

Description

connid

Is the handle to the connection you want to use. If you do not specify a connection, EXEC_SQL.DEFAULT_CONNECTION retrieves the primary connection handle from the cache.

Returns

TRUE or FALSE

Example


PROCEDURE esmoreresultsets(sqlstr VARCHAR2) IS
 conidODBC EXEC_SQL.CONNTYPE;
 nRes PLS_INTEGER;
 nRows PLS_INTEGER := 0 ;
 curID EXEC_SQL.CURSTYPE;
BEGIN
--
-- an ODBC connection string
--
  conidODBC := EXEC_SQL.OPEN_CONNECTION('connection_str_ODBC');
  curID := EXEC_SQL.OPEN_CURSOR(conidODBC);
  EXEC_SQL.PARSE(conidODBC, curID, sqlstr, exec_sql.v7);
  nRes := EXEC_SQL.EXECUTE(conidODBC, curID);
-- 
-- obtain results from first query in sqlstr
--
  WHILE (EXEC_SQL.FETCH_ROWS(conidODBC, curID) > 0) LOOP
  nRows := nRows + 1;
...
 END LOOP;
--
-- check whether this is an OCA connection. Does not continue for an Oracle
 
-- connection.
--
IF (EXEC_SQL.IS_OCA_CONNECTION != TRUE) THEN
 TEXT_IO.PUT_LINE('Not an OCA connection ');
 RETURN;
END IF;
--
-- check for more result sets
--
IF (EXEC_SQL.MORE_RESULT_SETS(conidODBC, curID)) THEN
 TEXT_IO.PUT_LINE(' more result sets ');
ELSE
 TEXT_IO.PUT_LINE(' no more result sets ');
END IF;
...
 EXEC_SQL.CLOSE_CONNECTION(conidODBC);
END;

See also

About the EXEC_SQL built-in package

EXEC_SQL built-in package

Built-in packages examples