本文主要是介绍Oracle数据库database link的使用,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
oracle数据库database link的使用:
1、在mpm用户下建立 database link
-- Create database link
create public database link JIRA
connect to JIRA
using '(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.216.38.233)(PORT = 1522))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = RATION)))';
create public database link JIRA
connect to JIRA
using '(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.216.38.233)(PORT = 1522))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = RATION)))';
2、带database link 的存储过程
CREATE OR REPLACE PACKAGE JIRA_ISSUELINK IS
PROCEDURE JIRA_ISSUE_RECORDS (L_MPM_PLAN_ID VARCHAR2,
-- ISSUE_RECORDS VARCHAR2,
o_Return_Int OUT INT,
o_Return_String OUT VARCHAR2);
-- ISSUE_RECORDS VARCHAR2,
o_Return_Int OUT INT,
o_Return_String OUT VARCHAR2);
END;
CREATE OR REPLACE PACKAGE BODY JIRA_ISSUELINK IS
PROCEDURE JIRA_ISS
这篇关于Oracle数据库database link的使用的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!