注册

disql执行sql文件出现The script file is not complete,last sql has not been executed.

zh 2023/04/18 2430 12 已解决

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm8
【操作系统】:
【CPU】:
【问题描述】*:
disql执行sql文件出现The script file is not complete,last sql has not been executed.我看了论坛其他求助帖,有说函数,触发线结尾要加" /"不知道是不是这样?
sql文件的内容为:
CREATE OR REPLACE FUNCTION "INET_ATON"( "f_address" IN varchar2 ) RETURN number
AS "o_address_number" number;
BEGIN
SELECT
to_number(regexp_replace("f_address", '([0-9]{1,3}).([0-9]{1,3}).([0-9]{1,3}).([0-9]{1,3})', '\1')) * 16777216 +
to_number(regexp_replace("f_address", '([0-9]{1,3}).([0-9]{1,3}).([0-9]{1,3}).([0-9]{1,3})', '\2')) * 65536 +
to_number(regexp_replace("f_address", '([0-9]{1,3}).([0-9]{1,3}).([0-9]{1,3}).([0-9]{1,3})', '\3')) * 256 +
to_number(regexp_replace("f_address", '([0-9]{1,3}).([0-9]{1,3}).([0-9]{1,3}).([0-9]{1,3})', '\4')) INTO "o_address_number";
RETURN "o_address_number";
END;/

image.png

回答 0
暂无回答
扫一扫
联系客服