![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
You can invoke a stored procedure from within your rules, using CALL or EXECUTE or TRANSFERCALL statements if it is procedural, or depending on its definition you can code it as a function. Your stored procedure can execute within a transaction or start a new transaction. Optionally, you can also invoke event rules to be run with a stored procedure.If your stored procedure is defined with a return value field, that is, a field defined with VRT=R, you can invoke it as either a function or a procedure from within your rules. If there is no return value field, you can invoke it only as a procedure. Upon completion of its execution, the fields of the stored procedure mapping, including the return value, are set to the values of the parameters as returned by the procedure, while input parameters stay intact.EXECUTE <stored_procedure>(<parameter1-value>,<parameter2-value>,…)TRANSFERCALL <stored_procedure>(<parameter1-value>,<parameter2-value>,…)
The TIBCO Object Service Broker name of the stored procedure mapping. The value to be passed for the parameter # N, counting input and input/output parameters only. If you specify NULL the parameter is passed as NULL; if you specify an empty string (''), the default, if any, is used for the parameter; all input and input/output parameters preceding the last output parameter must be specified; an unspecified parameter is considered an empty string.CALL <stored_procedure> WITH <parameter1>=<parameter1-value>&<parameter1>=<parameter1-value>&…EXECUTE <stored_procedure> WITH <parameter1>=<parameter1-value>&<parameter1>=<parameter1-value>&…TRANSFERCALL <stored_procedure> WITH <parameter1>=<parameter1-value>&<parameter1>=<parameter1-value>&…
The TIBCO Object Service Broker name of the stored procedure mapping. The TIBCO Object Service Broker name of the field representing the parameter. There is no need to specify all parameters; any unspecified parameter is considered an empty string.Functional invocation is applicable only for stored procedures with a return value, that is, a field with VRT = R.Using EXECUTE or TRANSFERCALL statements, you can invoke your stored procedures as separate TIBCO Object Service Broker transactions; no functional invocation is possible using these statements. However, if a return value is set by the procedure you can use the GETENDMSG tool to retrieve the return value, if any, set by the procedure. Use the same syntax as described in the CALL statement above when using EXECUTE or TRANSFERCALL statements.TIBCO Object Service Broker Shareable Tools about the GETENDMSG tool.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |