Re: ORA-00911 in Dynamic SQL

From: <sybrandb_at_yahoo.com>
Date: 9 Apr 2004 06:34:31 -0700
Message-ID: <a1d154f4.0404090534.53998fc9_at_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 - 15:34:31 CEST

This message: [ Message body ]
Next message: Hans Forbrich: "Re: create table in a procedure"
Previous message: sybrandb_at_yahoo.com: "Re: Does anyone know of a good location for a data set?"
In reply to: traceable1: "ORA-00911 in Dynamic SQL"
In reply to traceable1: "ORA-00911 in Dynamic SQL"
Next in thread: Hans Forbrich: "Re: create table in a procedure"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message