Re: ORA-00911 in Dynamic SQL

traceable1 wrote:
> I am trying to create a stored procedure with dynamic sql referencing
> the V$SESSION table (view). I need to use this dynamically, because
> the procedure will not compile if the user does not have access to
> this table. The $ is what's causing the trouble:
>
> declare v_sql varchar2(4000);
> begin
> v_sql := 'select * from v$session;';
> execute immediate (v_sql);
> end;
> /
>
>
> I've tried \ and double quotes, but they don't work. Any clues?
>
> THANK YOU!!!!
>
> trace

declare v_sql varchar2(4000);
begin
v_sql := 'select * from v$session';
execute immediate v_sql;
end;
/ Received on Thu Apr 08 2004 - 19:12:34 CDT