Oracle in a Nutshell

Name

CALL

Synopsis

CALL [schema.][package.]{function | procedure}[@dblink]
  (expr[,expr ...]) [INTO :host_variable [[INDICATOR] :indicator_variable]]

Executes a stored PL/SQL function or procedure.

Keywords

package

Name of the package that contains the function or procedure.

function

Name of a function to be executed.

procedure

Name of a procedure to be executed.

expr

Argument to the function or procedure.

INTO

Specifies (for a function) the name of the host variable that will hold the return value.

INDICATOR

Specifies the name of a variable that will indicate the condition of the host variable.

Common keywords and clauses: dblink, expr, schema.