I'm currently developing an eCommerce solution using the PL/SQL gateway with 9iAS and, having reached the internal testing phase, the ordering system appears to be working as it should, so long as you're using anything other than MSIE 4.x or Opera. If you attempt to run any of the stored procedures using either of these two, you get what looks like a standard server-side PL/SQL error page only there is no Oracle-specific error code, only the frustratingly cryptic: 'Name ".x" has an empty part'.
I suspect that the browser is not correctly submitting some specific MIME type information but, equally, I could be completely off the mark and could easily have made some screw up in my PL/SQL code...
Any pointers in the right direction would be appreciated as I would rather hang myself than tell potential users that they have to have a certain browser type in order to use the system.
Odds are if your page loads correctly in Netscape or some other browsers, and not in IE or Opera, it might be something rendered differently in the HTML.
I haven't used 9iAS yet, but generally the request the browsers send should all be the same, it's what they do after they get the information that varies. Try loading the page in Netscape or a working browser and saving the HTML which is generated, and see if that loads in the other browsers, could just be some mismatched tags that the other browsers don't handle the same.
Of course this could be way off the mark as I'm not sure exactly what the problem is :)
That's one reason I really dislike PL/SQL for Web applications. It's so rigid in what the procedures will accept. Scripting languages (perl, php, etc) are far more suited to this type of development in my experience. If extra variables are sent, you don't get "Request failed", you just don't need to handle them.
But glad you fixed your problem.