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