|Oracle9i SQL Reference
Release 1 (9.0.1)
Part Number A90125-01
ALTER TRIGGER to constraint_clause, 9 of 12
CALL statement to execute a routine (a standalone procedure or function, or a procedure or function defined within a type or package) from within SQL.
PL/SQL User's Guide and Reference for information on creating such routine
You must have
EXECUTE privilege on the standalone routine or on the type or package in which the routine is defined.
Specify the schema in which the standalone routine (or the package or type containing the routine) resides. If you do not specify
schema, Oracle assumes the routine is in your own schema.
Specify the type or package in which the routine is defined.
Specify the name of the function or procedure being called, or a synonym that translates to a function or procedure.
When you call a type's member function or procedure, if the first argument (
SELF) is a null
OUT argument, Oracle returns an error. If
SELF is a null IN argument, Oracle returns null. In both cases, the function or procedure is not invoked.
Restriction: If the routine is a function, the
INTO clause is mandatory.
In a distributed database system, specify the name of the database containing the standalone routine (or the package or function containing the routine). If you omit
dblink, Oracle looks in your local database.
Specify one or more arguments to the routine, if the routine takes arguments.
exprcannot be a pseudocolumn or either of the object reference functions
exprthat is an
OUTargument of the routine must correspond to a host variable expression.
INTO clause applies only to calls to functions. Specify which host variable will store the return value of the function.
Specify the value or condition of the host variable.
Pro*C/C++ Precompiler Programmer's Guide for more information on host variables and indicator variables
The following statement creates a procedure
updatesalary, and then calls the procedure, which updates the specified employee ID with a new salary.