SQL中调用ORACLE存储过程.docVIP

SQL Server 调用Oracle的存储过程 收藏 原文如下：通过SQL??Linked??Server?执行Oracle?存储过程小结1 举例我们可以通过下面的方法在SQL?Server中通过Linked?Server?来执行Oracle?存储过程。(1)??Oracle?PackagePACKAGE?Test_PACKAGE?AS???????TYPE?t_t?is?TABLE?of?VARCHAR2(30)???????INDEX?BY?BINARY_INTEGER;???????PROCEDURE?Test_procedure1??????(?p_BATCH_ID?IN?VARCHAR2,????????p_Number?IN?number,????????p_MSG?OUT?t_t,????????p_MSG1?OUT?t_t??????);???END?Test_PACKAGE;PACKAGE?BODY?Test_PACKAGE?AS???????PROCEDURE?Test_procedure1????????(?p_BATCH_ID?IN?VARCHAR2,??????????p_Number?IN?number,??????????p_MSG?OUT?t_t,??????????p_MSG1?OUT?t_t?????