Re: WAS : Problem to execute a package of designer 2000 with a browser

You have executed the procedure but it obviously does not create a page with any HTML in it ...hence the Content-type: text/html message...

to see if you are executing the procedure put a simple procedure at the end..

htp.p('woo hoo');

If this prints onto the screen you know that it is not a privileges problem

--
Cheers

Steve Bright

steve.bright_at_capgemini.co.uk

Frank van Bortel wrote in message <3720188A.9865BDCB_at_vnl.nl>...


>Jerome,


>

>in order to have someone to execute a package, not belonging to that user,

>you must:

>GRANT EXECUTE ON package_name TO user;

>

>However, as your server responds, it looks like something *is* happening,

>I would have expected something like 'URL not found'.

>

>jerome paire wrote:

>

>> Problem with WAS Oracle.

>> Acces to a package from a browser

>>

>> I want an user who is not

>> the owner of a package to acces or to execute it (this package is created

>> with Designor 2000) .

>>

>> The response of the browser is

>>

>> Content-type: text/html

>>

>> What is the problem?

>> is it a security problem or another ?

>>

>> what must i do with the privilege of this user to execute correctly this

>> package with a browser?

>>

>> I have created for this user a synonym of the package.

>> And this user have EXECUTE ANY PROCEDURE as system privileg.

>>

>> Thank you for your response.

>>

>> Jerome Paire.

>

>--

>Met vriendelijke groet,

>kind regards,

>

>Frank van Bortel

>Technical consultant Oracle

>V&L Informatica BV

>-----------------------------------------------

>Work                           Home

>Postbus 545                    Hunzestraat 4

>7500 AM Enschede               7555 WB Hengelo

>(31)53.434.1500                (31)74.242.5046

>

>