Re: Forms 4.5 and stored functions

From: Mark Styles <mcgill_at_lambic.co.uk>
Date: Fri, 28 Sep 2001 14:13:08 GMT
Message-ID: <n819rt02g07986r46r5nh92fhsikf02bo2_at_4ax.com>

[Quoted] On Tue, 25 Sep 2001 19:40:57 +0200, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
>"Mark Styles" <news_at_lambic.co.uk> wrote in message
>news:4s31rtkopd6ggg1n5b17d9c2m9i9174eve_at_4ax.com...
>> I'm trying to use a stored function in the WHERE clause of a cursor in
>> a Forms 4.5 procedure, but the procedure will not compile, complaining
>> that the function does not exist. Is there a way around this?
>
>This not a Forms issue, it is a privilege issue.
>You have privilege through a role and roles are disabled during compiling
>functions.
>Either grant the function directly (7.3/8.0)
>or us authid invoker in Oracle 8i

It turns out I have EXECUTE ANY PROCEDURE privilege. Shouldn't this be enough to allow me to compile?

[Quoted] I can compile my procedure as a stored procedure, but the compilation fails as a Forms procedure Received on Fri Sep 28 2001 - 16:13:08 CEST

This message: [ Message body ]
Next message: Mathew: "Re: Forecasting with RAM/Express and general advantages of ROLAP approach to data warehousing"
Previous message: Guenter Huerkamp: "Re: Using "Print Screen" in Oracle Forms6i"
Maybe in reply to: Mark Styles: "Forms 4.5 and stored functions"
In reply to Sybrand Bakker: "Re: Forms 4.5 and stored functions"
Next in thread: Mathew: "Re: Forecasting with RAM/Express and general advantages of ROLAP approach to data warehousing"
Reply: Sybrand Bakker: "Re: Forms 4.5 and stored functions"

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

Original text of this message