Oracle 使用 execute immediate 不能赋值问题

create or replace procedure sp_page(AllCount OUT NUMBER,
                                    ResultSet OUT PagePack.PageCursor,
                                    PageCurrent IN NUMBER,
                                    PageSize IN NUMBER,
                                    Fields IN VARCHAR,
                                    Condition IN VARCHAR,
                                    OrderGroup IN VARCHAR,
                                    IsCount IN NUMBER)
                                    Authid Current_User
as
pageindex number;
psize number;
sqlstr varchar2(1000);
sqlcomm varchar2(1000);
BEGIN

 

只需要创建存储过程中使用Authid Current_User赋值就即。

手动赋值可能赋不全，可参照以下：

以sys as sysdba身份登陆(命令窗口运行),显式赋予
grant select on dba_data_files to userName
grant select on dba_free_space to userName
grant select on dba_free_space_coalesced to userName