开发者

Oracle multiple statments do not run correctly

开发者 https://www.devze.com 2023-04-08 10:28 出处:网络
I have a file with 3 \"create type\" statements. I do not understand why, when I run the script it creates only the first type. When I open created type I see all three create statements inside开发者_

I have a file with 3 "create type" statements. I do not understand why, when I run the script it creates only the first type. When I open created type I see all three create statements inside开发者_如何学Python. What am I missing here?

CODE:

create type SplitPathTableType as table of varchar2(450);

create TYPE TSMNodesRecord AS OBJECT (
NodeID number(20),
IsDataNode number(1),
Path nvarchar2 (450),
ParentID number(20),
TimeStep number(20)
);

create type TSMNODESTABLE as table of TSMNODESRECORD;


You need / after each statement...

create type SplitPathTableType as table of varchar2(450);
/

create TYPE TSMNodesRecord AS OBJECT (
NodeID number(20),
IsDataNode number(1),
Path nvarchar2 (450),
vParentID number(20),
TimeStep number(20)
);
/

create type TSMNODESTABLE as table of TSMNODESRECORD;
/
0

精彩评论

暂无评论...
验证码 换一张
取 消