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,以编目存储过程。
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子句来将数据返回给调用者。
You may need to change the command delimiter away from the semicolon before entering the CREATE PROCEDURE statement.
在输入CREATE PROCEDURE语句前,您可能需要更改命令分隔符,使其不是分号。
These definitions are determined in the CREATE PROCEDURE statement of the federated procedure, not on the data source.
这些定义在联邦过程的CREATE PROCEDURE语句中决定,而不是数据源上。
The next step in creating the stored procedure is to issue the CREATE PROCEDURE DDL to register the procedure in the database.
创建存储过程的下一步是执行CREATE PROCEDUREDDL,在数据库中注册该存储过程。
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语句,确保传递的输入和输出参数的数量和数据类型都正确。
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子句中分三部分的名称,其中中间的部分标识包。
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子句中分三部分的名称,其中中间的部分标识包。
应用推荐