NexusDB AWE DLL (40 installations; binary) added to your shopping cart.

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

Home | Site Contents | Documentation | NexusDB Manual V4 | SQL Reference | SQL Statements | Control Statements