Re: Problem with views

From: Valeri Ivanov <vivanov_at_annuties.ma.ee>
Date: Mon, 30 Nov 1998 15:26:02 +0200
Message-ID: <36629ccf$0$11269@diablo.uninet.ee>

If anybody will have same problem

then you must install Oracle7 7.3.3.5.0 original patch release.

Valeri. Thanks.

Valeri Ivanov wrote in message <36627c2a$0$11443_at_diablo.uninet.ee>...
>Hello!
>
>I'm using Oracle 7.3.3 for NT and
>when I create view with UNION and call any functions in SELECT statements
>then I can't use GRANT command for this view. If I try use GRANT command
>then I lose
>a Oracle session.
>
>View like this:
>
>CREATE VIEW v_sample
>( field_1 ) AS
> SELECT f_sample(1) FROM DUAL
>UNION
> SELECT f_sample(2) FROM DUAL
>UNION
> SELECT f_sample(3) FROM DUAL
>
>Any ideas ?
>
>Valeri.
>vivanov_at_hireright.ee
>
>
>
>
>
>
>
>
>
Received on Mon Nov 30 1998 - 07:26:02 CST