oracle过程问题!!!!
我在一个包中建立一个过程如下:编译通过,没有任何错误,但我点击test时,输入一个参数,点击浏览数据时,弹出,没有执行语句句柄?这是什么意思
我的过程哪儿错啦?
PROCEDURE mostclassic_select(pageclassname in varchar2,tempcursor out T_CURSOR)
is
recordcount number;
begin
select productitemscount into recordcount
from page_pageclass t where pageclassname=pageclassname;
open tempCursor for
select pd.productname ,si.productid,si.clickcount,ps.songid
from statinfo si
inner join product_products pd on si.productid= pd.productid
inner join product_song ps on pd.productcontentid = ps.songid
where ',' || pd.categoryids || ',' like '%,'|| 85 || ',%'
and pd.producttypesid=1
and rownum<=recordcount
order by si.clickcount desc;
EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
SQL_CODE:= SQLCODE;
SQL_ERRM:= SQLERRM;
INSERT INTO ERROR_LOG VALUES
(ERROR_LOG_SEQ.NEXTVAL,
SQL_CODE,
SQL_CODE||' '||SQL_ERRM,
'BILLBOARD_PKG.HomeBillBoard_Select',
SYSDATE);
COMMIT;
end;