OWS doesn't run granted exec proc

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 - 03:36:49 CST