ODAC

TCustomOraPackage.ExecProcEx Method

Calls the stored procedures defined for a given package.

Class

TCustomOraPackage

Syntax

function ExecProcEx(Name: string; const Params: array of variant): variant;

Parameters
Name
Holds the name of the stored procedure.
Params
Holds the parameter values array.
Return Value
a result, if a stored procedure is a function, Null otherwise.

Remarks

Call the ExecProcEx method to call stored procedures defined for a given package. Name parameter is a name of a stored procedure.

If the sored procedure accepts or returns parameters, they must be supplied in the Params array as pairs of parameters' names and values so that every value would come immediately after its name. If the value for an input parameter was not included in the Params array, parameter default value is taken. If the parameter has no default value, NULL value is sent.

For example, the following is a stored procedure declaration in package DBMS_ALERT:

DBMS_ALERT.SIGNAL (
    name       IN   VARCHAR2,
    message   IN   VARCHAR2);

it may be called by this code:

MyOraPackage.ExecProcEx("SIGNAL", ["name", "MySignalName", "message", "MyMessage"]);

It is different from the way ExecProc is used.

See Also

© 1997-2022 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback