create or replace procedure RPTP_DSMAPUI ( a number, b number,c number,d number,e varchar2, mycursor out SYS_REFCURSOR )is begin open mycursor for ' select to_char(t.ParentID),to_char(t.ObjID),t.ViewID,t.Label,''1'' as SymbolType,t.TypeID,0 as LayoutType,0 as Status, 0 as TreeLevel,0 as AppProcID,0 as ServiceStatus from "IMAPTMDB"."TSNODE" t inner join "IMAPEAMDB"."TBL_SN" s on t.ProductFDN=s.dn where t.Label<>''HIDE'' ';end RPTP_DSMAPUI;
a number, b number,c number,d number,e varchar2,
mycursor out SYS_REFCURSOR
)is
begin
open mycursor for '
select to_char(t.ParentID),to_char(t.ObjID),t.ViewID,t.Label,''1'' as SymbolType,t.TypeID,0 as LayoutType,0 as Status,
0 as TreeLevel,0 as AppProcID,0 as ServiceStatus
from "IMAPTMDB"."TSNODE" t inner join "IMAPEAMDB"."TBL_SN" s on t.ProductFDN=s.dn
where t.Label<>''HIDE''
';end RPTP_DSMAPUI;