CALL

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

Syntax:

   CALL [schema.] [type.|package.] {function|procedure|method} [@dblink]
      (expr,...) [INTO :host_variable [[INDICATOR] :indicator_variable] ]

key

   indicator_variable is the value or condition of the host variable   

"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 




Back to the Top

Simon Sheppard
SS64.com