Sybernet / Supplied Functions Reference
Release 3.00
Oct 14, 2002

HTTP.SYBEXISTS

This function returns a Boolean (TRUE or FALSE) that is the result of evaluating the select statement passed to it. If the select statement returns 1 or more rows, TRUE is returned. If no rows are found, FALSE is returned.

Syntax

FUNCTION SYBEXISTS
(
    SELECT_STATEMENT              VARCHAR2
)
RETURN PL/SQL BOOLEAN;

Parameters

Parameter	Description
select_statement	The select statement to be evaluated

Returns

TRUE if it exists; FALSE otherwise.

Example

The following example illustrates how to call sybexists:

begin
    if http.sybexists('select * from http.http_register') then
        http.writeln('Success!');
    else
        http.writeln('Oops!');
    end if;
end;