Re: OWS doesn't run granted exec proc

Hello,

I have tried your scenario and it works for me. So I don't know directly to solve your problem...:-(

But few weeks ago I encountred similar behaviour as you described. Before I used to have the same name for the procedure as you have - MAIN - calling from www. It worked fine till I created the procedure to which I sended parameter like
http://myhost:8000/first/plsql/main?p_number=3400 and that time I got the same result that you. The only solution I found was that I changed the name of the procedure for different word and it worked !!! So I don't know wether the MAIN is some kind of keyword ...:-))

Good luck,

Erika

Klim Samgin wrote:
>
> Hi!
>
> I'm working on Oracle 8.0.5 under Solaris 2.6
> with Oracle Web Application Server 3.0.1.
>
> There are two db users, FIRST and SECOND,
> with CONNECT and RESOURCE roles.
>
> Both users have got Oracle Web toolkit installed
> (htp, htf, owa_util packages etc.) in their
> schemas.
>
> FIRST has got the following simple procedure:
>
> create or replace procedure main is
>
> BEGIN
>
> htp.htmlOpen;
>
> htp.headOpen;
> htp.title('This is a title');
> htp.headClose;
>
> htp.bodyOpen;
>
> htp.print('Hello, world!');
>
> htp.bodyClose;
>
> htp.htmlClose;
>
> END;
>
> And I see this 'Hello, world!' in the browser
> when type http://myhost:8000/first/plsql/main
> (FIRST and SECOND use 'first' and 'second' web agents).
>
> Ok,
>
> SQL> grant execute on main to second;
>
> When I type
> http://myhost:8000/second/plsql/first.main
> I've got only
>
> Content-type: text/html
>
> in the browser window!
>
> But where is 'Hello, world!'?
>
> When I revoke granted exec from SECOND
> and install main proc in SECOND schema,
> by typing
> http://myhost:8000/second/plsql/main
> I've got
> 'Hello, world!' in the browser window...
>
> Using synonym main in SECOND schema for first.main
> brings the same ('Content-type: text/html') result.
>
> Who knows the resolve of this problem?
>
> Thanks,
> Klim.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Feb 10 2000 - 09:03:32 CST