procedure SP_TBL_DICTIONARY_SELECT(
p_indexcode TBL_DICTIONARY.INDEXCODE%type,
cur_OUT out T_CURSOR
)is
begin
open cur_OUT for
select * from TBL_DICTIONARY d where d.indexcode in (p_indexcode)
end SP_TBL_DICTIONARY_SELECT; p_indexcode参数的值是'PU001','PU002',存储过程这么写正确吗?
p_indexcode TBL_DICTIONARY.INDEXCODE%type,
cur_OUT out T_CURSOR
)is
begin
open cur_OUT for
select * from TBL_DICTIONARY d where d.indexcode in (p_indexcode)
end SP_TBL_DICTIONARY_SELECT; p_indexcode参数的值是'PU001','PU002',存储过程这么写正确吗?
open cur_OUT for
'select * from TBL_DICTIONARY d where d.indexcode in (' || p_indexcode || ')';
select * from TBL_DICTIONARY d where instr(p_indexcode,d.indexcode)>0