17,086
社区成员
发帖
与我相关
我的任务
分享
create or replace type Userconfig as object
(
-- Attributes
CONFIG_ID integer,
USER_ID integer,
CONFIGDEF_ID integer,
LINE_NO integer,
CONFIG_NAME VARCHAR2(100),
DESCR VARCHAR2(500),
VALUE VARCHAR2(100)
);
create or replace type userconfig_table as table of userconfig;
create or replace procedure pro_addsystemsettings(listnode Userconfig_table) is
mynumic integer;
begin
for i in 1..listnode.count
loop
select count(*) into mynumic from GIS_USERCONFIG;
end loop;
end pro_addsystemsettings;