创建视图
CREATE or replace VIEW VM_DIPVMTest12017
AS
SELECT sys_guid() as ID ,NAME,AGE,(SELECT TARCOL FROM depvmvaluelist WHERE SRCCOL01=GENDER AND vmid='226bcca1-a309-40bb-a13d-fecd88ec6019') AS GENDER
,NVL(HOBBY,'123') as HOBBY ,CREATOR,CREATEDTIME,LASTMODIFIER,LASTMODIFIEDTIME,sys_guid() as GUID
FROM DIPVMTest12017
然后.net跨库保存数据为System.Byte[]
解决方法:
1. 创建一个function
CREATE OR REPLACE FUNCTION DIP_GET_GUID
RETURN CHAR
IS
v_guid CHAR (36);
v_guid_part_one CHAR (8);
v_guid_part_two CHAR (4);
v_guid_part_three CHAR (4);
v_guid_part_four CHAR (4);
v_guid_part_five CHAR (12);
BEGIN
SELECT SYS_GUID ()
INTO v_guid
FROM DUAL;
v_guid_part_one := SUBSTR (v_guid, 0, 8);
v_guid_part_two := SUBSTR (v_guid, 8, 4);
v_guid_part_three := SUBSTR (v_guid, 12, 4);
v_guid_part_four := SUBSTR (v_guid, 16, 4);
v_guid_part_five := SUBSTR (v_guid, 20, 12);
v_guid :=
CONCAT
(CONCAT
(CONCAT
(CONCAT (CONCAT (CONCAT (CONCAT (CONCAT (v_guid_part_one,
'-'),
v_guid_part_two
),
'-'
),
v_guid_part_three
),
'-'
),
v_guid_part_four
),
'-'
),
v_guid_part_five
);
RETURN (v_guid);
END DIP_GET_GUID;
2. 修改创建的视图,用DIP_GET_GUID()函数代替sys_guid()函数
CREATE or replace VIEW VM_DIPVMTest12017
AS
SELECT DIP_GET_GUID() as ID ,NAME,AGE,(SELECT TARCOL FROM depvmvaluelist WHERE SRCCOL01=GENDER AND vmid='226bcca1-a309-40bb-a13d-fecd88ec6019') AS GENDER
,NVL(HOBBY,'123') as HOBBY ,CREATOR,CREATEDTIME,LASTMODIFIER,LASTMODIFIEDTIME,sys_guid() as GUID
FROM DIPVMTest12017
用.net跨库同步