Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 

CALL Statement

Description

In CUBRID, the CALL statement is used to call a method defined in the database. Both table and record methods can be called by the CALL statement.

Syntax

CALL method_call [ ; ]

method_call :

? method_name ( [ arg_value [ {, arg_value }_ ] ] ) ON call_target [ to_variable ]

? method_name ( call_target [, arg_value [ {, arg_value }_ ] ] ) [ to_variable ]

arg_value :

? any CSQL expression

call_target :

? an object-valued expression

to_variable :

? INTO variable

? TO variable

  • The method_name is either the method name defined in the table or the system-defined method name provided with CUBRID. A method requires one or more parameters. If there is no parameter for the method, a set of blank parentheses must be used.
  • call_target can use an object-valued expression that contains a class name, a variable, another method call (which returns an object). To call a class method for a class object, you must place the CLASS keyword before the call_target. In this case, the table name must be the name of the class where the table method is defined. To call a record method, you must specify the expression representing the record object. You can optionally store the value returned by the table or record method in the to_variable. This returned variable value can be used in the CALL statement just like the call_target or arg_value parameter.
  • Calling nested methods is possible when other method_call is the call_target of the method or given as one of the arg_value parameters.