procedure output的意思|示意

Let's first consider how to return the output of the XMLQuery function to variables declared in a stored procedure.

我们首先考虑如何将XMLQuery函数的输出返回给存储过程中声明的变量。

Solution: Check the CREATE PROCEDURE statement and make sure you are passing the correct number of input and output parameters with proper data types.

解决方案： 检查 CREATE PROCEDURE 语句，确保传递的输入和输出参数的数量和数据类型都正确。

In the output from calling the stored procedure, you can see the difference between extracting an XML element, and extracting the value of an XML element.

在调用存储过程的输出中，可以看到提取xml元素与提取XML元素值之间的差异。

A developer that creates a CMP bean that USES a stored procedure knows how to invoke this stored procedure and handle the input and output parameters.

创建过使用存储过程的CMP bean的开发人员知道如何调用这个存储过程，以及如何处理输入和输出参数。

Stored procedure support — You can create and run stored procedures that contain XML data type (input or output) parameters or return XML data.

对存储过程的支持——您可以创建和运行包含X ML数据类型(输入或输出)的参数或者返回XML数据的存储过程。

In order to access all the information returned by a stored procedure call, developers need to register all the output parameters beforehand and assign the result of the call to a ResultSet object.

为了访问存储过程调用返回的所有信息，开发人员需要预先注册所有的输出参数，并将调用的结果赋给一个ResultSet对象。