In this case, the procedure exits immediately and returns a failing status to the caller.
在这种情况下,过程会立即退出并向调用者返回一个错误状态。
In the latter case, the procedure returns a successful execution status to the caller.
对于后一种情况,过程向调用者返回一个成功的执行状态。
The stored procedure, when using the default connection, will get its connection properties passed from the caller.
使用默认连接时,存储过程从调用者那里获得它的连接属性。
Processing stops immediately when this statement is executed, and the procedure return code to the caller is the value of SQLERROR.
在执行该语句时处理将立即停止,而过程返回给调用者的代码是SQLERROR的值。
The caller must ensure to perform COMMIT after calling this procedure to save the explain information.
调用者必须在调用这个过程后执行COMMIT来保存解释信息。
If the cursor is closed using the close statement before the return of the SQL procedure, the cursor result set will not be returned to the caller or client application.
如果在返回SQL过程之前使用close语句关闭游标,那么游标结果集就不会返回到调用者或客户机应用程序。
The RPC server bundles up the results of the procedure and sends those results back to the caller.
RPC服务器将过程的结果打包并将那些结果发送回调用者。
Of course, it is possible to allow the caller of the stored procedure to further control the execution.
当然,该存储过程的调用者还可以进一步扩展它的执行。
In the DB2 procedure example in Table 6, the SIGNAL statement is used to generate a user-defined SQLSTATE and a message that is returned to the caller through the SQLCA.
在表6的DB 2过程示例中,signal语句用于生成用户定义的SQLSTATE和一条消息,该消息通过SQLCA返回给调用方。
The caller must perform COMMIT after calling this procedure to save the explain information.
调用者必须在调用这个过程后执行COMMIT来保存explain信息。
To avoid this scenario, use the RETURNS clause of the CREATE PROCEDURE statement to return data to the caller.
要避免这种情况,使用CREATEPROCEDURE语句的returns子句来将数据返回给调用者。
RETURN: Returns an integer and the flow of control to the caller of the stored procedure.
RETURN:将一个整数值和控制流返回给存储过程的调用方。
This procedure dumps all the collected trace data into a result set which it returns to the caller.
该过程将所有收集到的跟踪数据dump到一个结果集中,并将该结果集返回给调用者。
In this scenario, the procedure completes successful execution and returns a return code of 0 to the caller.
在这个场景中,过程成功执行并将0的返回码返回给调用者。
Execution context is reverted to the original caller only after execution of the procedure or when a revert statement is issued.
只有在执行此程序之后,或发出revert陈述式时,执行内容才会还原成原始呼叫端。
When a stored procedure that has been signed with a certificate executes, the permissions granted to the certificate user are merged with those of the caller.
当您执行已经使用某个凭证签署的预存程序时,授与凭证使用者的权限就会与呼叫端的权限合并。
When a stored procedure that has been signed with a certificate executes, the permissions granted to the certificate user are merged with those of the caller.
当您执行已经使用某个凭证签署的预存程序时,授与凭证使用者的权限就会与呼叫端的权限合并。
应用推荐