OWAS public access

Hi Ya'll:

I would like to create one DAD and one PL/SQL agent that I can use to call stored procedures from different schemas. I'm using owas 3.01

I setup a test with two users. User 1 called 'pub' and user 2 called 'USERA'. Here is what I've done.

1. create a DAD with user 'pub' and it's password stored in the DAD
2. create a PL/SQL agent 'pubagent' using the DAD above called 'pub'. - had webserver utilitiy create owa.utils package in user pub account.
3. create synonyms for owa.utils package in USERA account from 'pub' account
4. granted execute on owa.utils package for USERA
5. created a procedure create or replace procedure USERA.TEST as begin htp.p ('procedure in USERA<br>'); end;
6. granted user 'pub' execute on procedure object 'USERA.TEST'
7. called my procedure from the web using http://www.mydomain.com/pub/plsql/usera.test

This returns a web page with just one thing on it: Content-type: text/html

[Here is what has worked]
8) if a create the same procedure 'test' in the schema 'PUB' it works fine. 9) i also created another DAD and AGENT that did not have user and password stored in the DAD. When I called the URL it prompted for a user name and password, i put in USERA and password for USERA account. It ran the USERA.TEST just fine.

How can I get my 'public' agent to call procedures from another schema?

Thanks!
Juan Received on Mon Apr 27 1998 - 00:00:00 CDT