From: anacedent@hotmail.com   
      
   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;   
   /   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)