CALL statement

Wed, 03/04/2009 - 20:02 |  hdanzl

Invoke a user-defined procedure.


Syntax

<call statement> ::= CALL <routine invocation>


Usage

The CALL statement is used to invoke a user-defined procedure.


Notes

♦ The CALL statement can only invoke a procedure.
♦ The number and types of arguments passed to the procedure call must match the SQL parameter declarations in the procedure definition.


Examples

1) The following example invokes a user-defined procedure using dynamic parameters to pass values:

       CALL addCourse( :courseID, :courseName, :department, :numCredits );


Conformance

SQL:2003 standard

-

Core SQL
‹ Control StatementsupRETURN statement ›
Print this chapter |  Login or register to post comments |  Send to friend |  PDF version |  metadata Tags:
Home | Site Contents | Documentation | NexusDB Manual V4 | SQL Reference | SQL Statements | Control Statements

Powered by Drupal and Drupal Theme created with Artisteer.