Re: ORA-00911 in Dynamic SQL

From: <sybrandb_at_yahoo.com>
Date: 9 Apr 2004 06:34:31 -0700
Message-ID: <a1d154f4.0404090534.53998fc9@posting.google.com>

traceable1_at_hotmail.com (traceable1) wrote in message news:<8551d8c9.0404081235.4d9251c_at_posting.google.com>...
> 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.

Untrue. Create the procedure with authid current_user or grant direct privilege to the user, and dump the dynamic sql. Not sure why you would need any user to do this though.

Sybrand Bakker
Senior Oracle DBA Received on Fri Apr 09 2004 - 08:34:31 CDT