Execute Procedure
Invokes a database procedure.
Syntax
[returnfield = ] execute procedure [owner.]proc_name
[(param_name=param_spec {, param_name=param_spec})]
return_field
Specifies an integer variable that contains the return value of the procedure
[owner.]proc_name
Specifies the name of the procedure being invoked. proc_name can be a literal name or a host string variable. You can specify an owner name when you use a literal value for the proc_name. When you use a host variable, the variable can contain either the procedure name or the owner.proc_name string. You cannot specify the owner and the procedure name in separate variables.
param_name
Specifies the name of the parameter being passed. param_name must be a valid Ingres name specified using a quoted or unquoted string or a host variable.
Each param_name must match one of the parameter names in the parameter list of the procedure's definition.
param_spec
The value of the parameter. The param_spec can be a literal value, a host variable containing the value to be passed (:hostvar), or a host variable passed by reference (byref(:host_variable)).
Description
The execute procedure statement executes the database procedure identified by proc_name. The execute procedure statement allows you to call a database procedure, even if the procedure has not been declared as part of an ABF or Vision application. You also can use a callproc statement to execute a procedure, but the procedure must be declared to ABF or Vision. You cannot specify an owner name when you use the callproc statement.
You can include execute procedure statements in a 4GL execute immediate statement, provided no parameters are passed using the byref clause. An execute procedure statement called by an execute immediate statement cannot return a status to the application.