You can create federated procedures using the create procedure (Sourced) statement.
可以使用CREATE PROCEDURE (Sourced)语句创建联邦过程。
Now the CREATE procedure statement succeeds, and the stored procedure runs successfully.
现在，CREATE procedure语句成功了，存储过程成功运行。
It also shows how to take advantage of the result set syntax in the CREATE PROCEDURE statement.
还演示如何在CREATE procedure语句中利用结果集语法。
Execute the CREATE PROCEDURE DDL from the source against the target server to catalog the stored procedure
在目标服务器上执行来自源服务器的CREATE PROCEDUREDDL，以编目存储过程。
In this example, we have chosen to fix the CREATE PROCEDURE statement instead of modifying the source code.
在这个例子中，我们选择修改CREATE procedure语句而不是修改源代码。
First look at the CREATE procedure statement to confirm what parameters each of the stored procedures expects.
先看一下CREATE PROCEDURE语句，确定每个存储过程所需要的参数。
To avoid this scenario, use the RETURNS clause of the CREATE PROCEDURE statement to return data to the caller.
要避免这种情况，使用CREATE PROCEDURE语句的returns子句来将数据返回给调用者。
These definitions are determined in the CREATE PROCEDURE statement of the federated procedure, not on the data source.
这些定义在联邦过程的CREATE PROCEDURE语句中决定，而不是数据源上。
You may need to change the command delimiter away from the semicolon before entering the CREATE PROCEDURE statement.
在输入CREATE PROCEDURE语句前，您可能需要更改命令分隔符，使其不是分号。
If any of the above queries fail to return the desired remote procedure, error SQL1253N is thrown during CREATE procedure.
如果以上任何查询无法返回所需的远程过程，那么在执行CREATE PROCEDURE期间会抛出错误SQL 1253n。
The next step in creating the stored procedure is to issue the CREATE PROCEDURE DDL to register the procedure in the database.
创建存储过程的下一步是执行CREATE PROCEDUREDDL，在数据库中注册该存储过程。
Listing 9 contains a code example of the SQL CREATE procedure statement used to register an RPG program as an external stored procedure.
清单9包含一个用于将一个R PG程序注册为一个外部存储过程的SQLCREATE PROCEDURE语句的代码示例。
Generate the Create Procedure DDL, incorporating the user's modifications to the DDL, such as schema, WLM environment, and collection ID.
根据用户对ddl的修改，例如对模式、WLM环境和集合id的修改，生成Create Procedure ddl。
In the CREATE procedure statement, you can specify several options for that stored procedure. Here are a few of them that have significance.
在CREATE procedure语句中，可以为存储过程指定几个选项。
For some browsing applications to parse the CREATE PROCEDURE statement itself, you need the command delimiter to be something other than a semicolon.
对于要分析CREATE PROCEDURE语句本身的某些浏览应用程序而言，需要采用不是分号的其它命令分隔符。
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语句，确保传递的输入和输出参数的数量和数据类型都正确。
And as before, you can fix the problem by re-issuing the correct CREATE PROCEDURE statement. For more information about Java VM type signatures, go to this url.
而且与前面一样，可以通过重新发出正确的CREATE PROCEDURE语句来纠正这个问题。
The CREATE PROCEDURE statement provides special syntax for Oracle routines in packages, a three-part name in the SOURCE clause where the middle part identifies the package.
CREATE procedure语句为包中的Oracle例程提供了特殊语法，即source子句中分三部分的名称，其中中间的部分标识包。
If two or more data source procedures have identical schema and procedure names, but different Numbers of parameters, then the number of parameters can be specified in the CREATE procedure statement.
如果两个或更多的数据源过程具有相同的模式和过程名，但是参数数量不同，那么可以在CREATE procedure语句中指定NUMBEROFPARAMETERS。
But first you should create your stored procedure in the destination database MYSAMPLE.
但是，首先应该在目标数据库mysample中创建存储过程。
To enable dynamic invocation, you should create a stored procedure that takes two parameters and invokes the mining flow with this user input.
为了实现动态调用，需要创建一个存储过程，它接受这两个参数并通过此用户输入调用挖掘流。
This is useful if you plan to drop the stored procedure and not create it again.
如果您打算删除存储过程并且不会重新创建它，那么这个操作就有用了。
Then, create a job and use a procedure node that will issue system commands to generate and run a batch file.
然后，创建一个工作，并使用发布系统命令的程序节点，以生成并运行一个批文件。
Although it would be possible to create a stored procedure in the relational case, for this case it would be much more complicated.
虽然可以在关系情况下创建存储过程，但对于这种情况可能会复杂得多。
It is easy to create SQL stored procedures, so for each stored procedure with INOUT and OUT parameters, you can create a wrapper stored procedure.
SQL存储过程的创建十分容易，因此，对于每个带有INOUT和OUT参数的存储过程，都可以创建一个包装器存储过程。
Stored procedure support — You can create and run stored procedures that contain XML data type (input or output) parameters or return XML data.
对存储过程的支持——您可以创建和运行包含XML数据类型(输入或输出)的参数或者返回XML数据的存储过程。
First, let's create a simple stored procedure SP_GET_LOC that returns the location for a given department from the table ORG (step 1).
首先，创建一个简单的存储过程SP_GET _ LOC，它从表org中返回某个给定部门的位置(步骤1)。
The following Outlines and details the procedure to create such a plug-in.
下面将分别对创建此类插件的过程进行概要以及详细的介绍。
Here, you need to start a new project, which can be used to create a new stored procedure that can be deployed inside the SAMPLE database.
在这里，首先需要启动一个新项目，该项目用于创建可部署在SAMPLE数据库内的新存储过程。
Once you create the SQL procedure that returns a result set, you might want to call it and retrieve the result set.
一旦创建了返回结果集的SQL过程，可能需要调用它并检索结果集。
应用推荐