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