Oracle multiple statments do not run correctly
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;
/
精彩评论