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 Oracle Commands:


PACKAGE - ALTER PACKAGE
PROCEDURE - ALTER PROCEDURE
EXEC

 CODE_PIECES
 CODE_SIZE
 DBA_SOURCE         ALL_SOURCE          USER_SOURCE

 
Copyright © 1999-2024 SS64.com
Some rights reserved