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