Navigation:  NexusDB Guide > SQL Reference > SQL Statements > Control Statements >

CALL statement

 Previous pageReturn to chapter overviewNext page

NexusDB V3 Manual

CALL statement

button_main button_prev button_next

NexusDB Manual V3 > SQL Reference > SQL Statements > Control Statements

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

 

© Nexus Database Systems Pty Ltd.

nexus_logo