SqlStatement:='Select User_ID,'+UserRoleColumnName
+'From T_Pub_UserRole
Where User_ID In (Select User_ID
From T_Pub_User
Where Dept_ID=
(Select Dept_ID
From T_Pub_User
Where User_ID='+astg_UserID+') And Company_ID=(Select Company_ID From T_Pub_User Where User_ID="'+astg_UserID+'"))';
Execute Immediate SqlStatement;这个语句的结果集是多个,如何对它使用游标呢?
+'From T_Pub_UserRole
Where User_ID In (Select User_ID
From T_Pub_User
Where Dept_ID=
(Select Dept_ID
From T_Pub_User
Where User_ID='+astg_UserID+') And Company_ID=(Select Company_ID From T_Pub_User Where User_ID="'+astg_UserID+'"))';
Execute Immediate SqlStatement;这个语句的结果集是多个,如何对它使用游标呢?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货