CALL

Execute a procedure or function from within SQL (may be used for both stored rocedures/packages and standalone routines).

Syntax:

   CALL [schema.] item_to_call 

   CALL [schema.] [package.] item_to_call [INTO :host_variable [[INDICATOR] :indicator_var] ]

   CALL [schema.] [type.] item_to_call [INTO :host_variable [[INDICATOR] :indicator_var] ]

Key

   item_to_call:    function  [@dblink] (expr,...)
                    procedure [@dblink] (expr,...)
                    method    [@dblink] (expr,...)

   indicator_var:   The value or condition of the host variable   

Example

CALL place_order(453);

"Ever notice that 'What the hell' is always the right decision?" - Marilyn Monroe

Related Commands:

PACKAGE - ALTER PACKAGE
PROCEDURE - ALTER PROCEDURE
EXEC

Related Views:

 CODE_PIECES
 CODE_SIZE
 DBA_SOURCE         ALL_SOURCE          USER_SOURCE

Equivalent SQL Server command:

EXECUTE