刚用存储过程,此存储过程错误,请指正
CREATE OR REPLACE PROCEDURE PROC_USER_DEP (
in_user_id in VARCHAR2,
in_user_pwd in VARCHAR2,
out_node_id out VARCHAR2,
out_tree_pk out VARCHAR2,
out_id out VARCHAR2)
AS
BEGIN
select t1.node_id,
t1.TREE_PK
t2.id into out_id
from HBGH_PUB_TREE t1 ,
(
select id from Hbgh_User_Info where User_Uid='0311admin' and user_pwd='admin'
) t2
where t1.node_id =
(
select substr(PURVIEWID,1,instr(PURVIEWID,';')-1) powerid from Hbgh_User_Info
where User_Uid='0311admin' and user_pwd='admin'
) ;
EXCEPTION
WHEN NO_DATA_FOUND THEN
NULL;
WHEN OTHERS THEN
-- Consider logging the error and then re-raise
RAISE;
END PROC_USER_DEP;