try:
修改最后一行
and products.id not in
( select NPRODUCTID from DMCATEGORYPRODUCT where NCATEGORYID = 1 )
为
and not exists
( select 1 from DMCATEGORYPRODUCT where NCATEGORYID = 1 and
products.id=nproductid);
修改最后一行
and products.id not in
( select NPRODUCTID from DMCATEGORYPRODUCT where NCATEGORYID = 1 )
为
and not exists
( select 1 from DMCATEGORYPRODUCT where NCATEGORYID = 1 and
products.id=nproductid);
用ref cursor你查一下论坛中 关于 “结果集” 的贴子。您这个我没明白什么意思?
需要写一个包:
create or replace package pag_cs_power as type c_Type is ref cursor;
FUNCTION FUN_CS_GETDICTLIST(
v_DictIndex in varchar2) return c_Type;end pag_cs_power;存储过程代码:FUNCTION FUN_CS_GETDICTLIST(
v_DictIndex in varchar2) return c_Type
as
c_cursor c_Type;
begin
open c_cursor for
select DICTID,DICTNAME FROM SYS_DICT WHERE DICTINDEX = v_DictIndex;
return c_cursor;
end FUN_CS_GETDICTLIST;