Sybernet / Supplied Functions Reference Release 3.00 Oct 14, 2002

HTTP.SP_CRON_WAIT

This function allows your stored procedure to wait for the completion of a procedure submitted to Sybercron.

Syntax

FUNCTION SP_CRON_WAIT
(
    ROW_ID                        NUMBER
)
RETURN NUMBER;

Parameters

row_id

Returns

For stored procedures 0 if successful. For UNIX executables the exit status.

Example

The following example illustrates how to call sp_cron_wait:

declare
    row_id binary_integer;
begin
    row_id:=http.sp_cron_insert
    ( 
        PROCNAME   => './HelloWorld'
    ,   SCRIPTNAME => '../htdocs/datafile'
    )   ;
    if (http.sp_cron_wait(row_id) = 0) then
        http.write('Success!');
    else
        http.write('Oops!');
    end if;
end;