Re: views in a stored procedure

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: Sat, 11 Apr 1998 01:46:18 GMT
Message-ID: <6gmi23$9kk@bgtnsc03.worldnet.att.net>

On Wed, 8 Apr 1998 22:08:35 -0400, "John Wang" <rwang_at_erols.com> wrote:

>I am trying to write a stored procedure. I am using some views. And every
>time I compile, I get an error. For example, I am using V$parameter, the
>error is sys.v_$parameter must be declared. why is that? does that mean I
>cannot use views in a stored procedure?

If I'm not mistaken, access to the view must come via your user-id and not a role. Try logging on as SYS, and doing:

	grant select on v$parameter
	to your_user_id;

Strange that you are getting an error on v_$parameter. Is that the underlying table? Maybe you need access to that as well.

Jonathan Received on Fri Apr 10 1998 - 20:46:18 CDT