Re: db_block_size

As the user SYS issue:

grant select on v_$parameter to USERNAME

where username is the user creating the procedure below, then the synonym v$parameter will work.

V$parameter is a public synonym,
V_$parameter is a view.

Since in the procedure you don't have the priveleges from a role, you can't 'see' v_$parameter in the stored proc until someone grants access directly to you.

On Fri, 31 May 1996 14:01:08 GMT, chuckh_at_dvol.com (Chuck Hamilton) wrote:

>Is there any way to get the db_block_size parameter in a stored
>procedure/function? I tried selecting v$parameter but that doesn't
>seem to work in a stored procedure.
>--
>Chuck Hamilton
>chuckh_at_dvol.com
>
>Never share a foxhole with anyone braver than yourself!
Received on Fri May 31 1996 - 00:00:00 CEST