Re: Sorry, sorry! Again the above in english!!!
Date: Tue, 22 Feb 2000 12:48:25 -0300
Message-ID: <88u9at$3bd$1_at_ul3.satlink.com>
[Quoted] Did you create a public synonym for the view ? (I guess you did)
[Quoted] You don't explain about the procedure with the default where. Did you try a
very simple form, with the view as a base table, but with all the default
triggers ?
Xophe_at_gmx.de escribió en mensaje <38B2A4FC.D6E8494E_at_gmx.de>...
>Hallo,
>
>does anyone has a clue, how to solve the following problem?
>
>I created a view over three tables. With a 'grant select ...' i give
>other
>users access to the view.
>In my Forms6.0 application I a block is based on that view.
>In a procedure I give a default where to this block and then do
>an execute_query. When it's me who is connected to the database,
>the Forms application works fine. If someone else is trying to start
>the application then the execute_query causes an Error:
>'unable to perform query'. Pressing 'Shift-F1' shows: 'ivalid column'.
>The only invalid column I can see in this automatically generated
>query is ROWID. Only the where-clause is from me.
>
>I tested with SQL*Plus:
>Me and everybody else can do a 'Select *' for this view.
>Me and everybody else cannot do a 'Select rowid' for this
>view.
>
>Even though the application works fine for me.
>I'd like the apllication to run for everybody else, too, without
>having everybody to create this view himself.
>
>Can I somehow get rid of this rowid in automatic generated
>queries? Any other suggestions?
>
>Thank you very much for your help!
>Gudrun Janssen
>
>
Received on Tue Feb 22 2000 - 16:48:25 CET