Re: Forms 4.5 and stored functions
Date: Fri, 28 Sep 2001 19:37:52 +0200
Message-ID: <tr9dv3ppfcqe29_at_news.demon.nl>
Answer embedded.
Hth,
Sybrand Bakker, Senior Oracle DBA
"Mark Styles" <mcgill_at_lambic.co.uk> wrote in message
news:n819rt02g07986r46r5nh92fhsikf02bo2_at_4ax.com...
> 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?
No, this still needs to be a *direct* privilege in 7.3 and 8.0
Also you need to have a synonym to your procedure if you do not own it, or
prefix it's invocation with the owner name.
>
> I can compile my procedure as a stored procedure, but the compilation
> fails as a Forms procedure
>
Received on Fri Sep 28 2001 - 19:37:52 CEST