Hi
I ran the same command which is there in the install guide
ORACLE:
CMN_DBLINK_SP( P_DB_LINK_NAME VARCHAR2,
P_CLARITY_DB_HOST_NAME VARCHAR2,
P_CLARITY_DB_PORT NUMBER,
P_CLARITY_DB_SERVICE_NAME VARCHAR2,
P_CLARITY_SCHEMA_NAME VARCHAR2,
P_CLARITY_PASSWD VARCHAR2
)
Example: Oracle DBLINK Creation
EXEC CMN_DBLINK_SP ('PPMDBLINK','<hostname>',1521,'CLARITY','NIKU','NIKU');
MSSQL:
CMN_DBLINK_SP @P_DB_LINK_NAME VARCHAR(30),
@P_CLARITY_DB_HOST_NAME VARCHAR(30),
@P_CLARITY_SCHEMA_NAME VARCHAR(30),
@P_CLARITY_USER VARCHAR(30),
@P_CLARITY_PASSWD VARCHAR(30)
Installation Guide
Example: Microsoft SQL DBLINK Creation
CMN_DBLINK_SP 'PPMDBLINK','<hostname>','NIKU','NIKU','NIKU'
Regards
Suman Pramanik