PL/SQL web strange problem

Hi all

I've a strange problem. I have a PL/SQL procedure on my database. For testing, it simply outputs hello world using htp, and then also inserts a row into a known table (so that I know it has executed even if the answer can't be seen).

The package loads successfully, I have a public synonym set up for it so typing :

execute my_package.my_proc;

successfully executes.

I have had a DAD set up for me.
Now, when I log into https://myserver/pls/myapp/my_package.my_proc I get asked for my password. This works fine. If I supply the correct password I get through, but if I get it wrong, I fail authentication. So far so good.

However, I always get a 404 error from the page. Moreover, the procedure does *not* get executed (as the table row addition never occurs), so it is a problem *before* the procedure itself.

I am stumped as to what the problem might be. I am guessing that perhaps the machine with my database (different to the application server I *think*) might be missing some vital configuration, or perhaps I am missing some permissions I need to perform this operation.

I know that when I try to do owa_util.showpage that doesn't work, or maybe it should be oas_public.owa_util.showpage. Perhaps this is a clue. The server version for my database is 8.1.7 I think.

I'm not a dba, but I do know the dba. what can we do to solve this problem?

Thanks alot!

Bob (boblebrocq lives at hot mail * ) Received on Sat Mar 13 2004 - 04:28:25 CST