Sybernet / Supplied Functions Reference Release 3.00 Mar 27, 2003

HTTP.SP_CRON_INSERT_PARAMETER

This function allows you to specify and then pass parameters to the procedure that you registered by calling SP_CRON_INSERT. While HTTP.SP_CRON_INSERT allows you to register a stored procedure, this function allows you to specify the parameters that are passed to that procedure.

This function will raise an exception if you attempt to pass an invalid parameter name to the procedure that you registered by calling SP_CRON_INSERT. If the procname that you registered is a script or executable, however, then all parameters are valid and are case-sensitive. Parameters passed to scripts or executables are passed in order by name, not in the order they were submitted to this function. arg1, arg2, and arg3 are typical names, but if you pass more than 9 names, then arg01, arg02, arg03 are better choices here.

When invoking a script or executable, parameter names are case-sensitive. When invoking a stored procedure, parameter names are case-insensitive. If you are passing a case-sensitive parameter name to SP_CRON_INSERT_PARAMETER because it is case-sensitive and you double quoted its name when declared in Oracle, then specify that name as case-sensitive and do not quote it when passed to this function.

Syntax

FUNCTION SP_CRON_INSERT_PARAMETER
(
    ROW_ID                        NUMBER
,   NAME                          VARCHAR2
,   VALUE                         VARCHAR2
)
RETURN NUMBER;

Parameters

row_id

name

value

Returns

-1 if an error occurs. Otherwise, the ROW_ID you passed.

Example

This example illustrate how to register a stored procedure and how two parameters are passed when it is invoked:

declare
    row_id binary_integer;
begin
    savepoint oops;
    row_id:=http.sp_cron_insert
    (
        PROCNAME   => 'http.dbo.sp_html_xmas'
    ,   EMAIL      => 'nospam@nospams.com'
    ,   DATENAME   => 'DECEMBER'
    ,   DAY        => '25'
    ,   HOUR       => '8'
    )   ;

    if (row_id != -1) then
    row_id:=http.sp_cron_insert_parameter
    (
        ROW_ID     => row_id
    ,   NAME       => 'name1'
    ,   VALUE      => 'value1'
    )   ;

    if (row_id != -1) then
    row_id:=http.sp_cron_insert_parameter
    (
        ROW_ID     => row_id
    ,   NAME       => 'name2'
    ,   VALUE      => 'value2'
    )   ;

    if (row_id != -1) then
        commit work;
    else
        rollback to savepoint oops;
    end if;
end;

See Also