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.
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.