Re: Using Oracle WebServer

[ copy mailed ]

Patti Todd <ptodd_at_symantec.com> wrote:
> Anyone know how to access stored procedures via HTML with Oracle
> WebServer 2.x? [...] I need to access already
> created stored procedures (with parameter passing) from my web pages
> without making changes to those stored procedures.

Hmm. Well, you don't need to do anything to the stored procedures in order to access them via the PL/SQL Agent, as long as the user that the PL/SQL Agent connects as has permissions to execute them. A URL of the form:

http://host:port/ows/service/owa/schema.procedure

should access the procedure in the schema, using user/password specified in the configuration file for service "service". However, if you want to pass parameters, you'll need to have a form set up to accept those paramters, or encode them into the query string directly: "...procedure?var=val&var2=val2&...." Don't forget to URL-encode special characters if you hard-code the query string.

However, is this what you want? You're not going to get any results that the web browser can display like this. More likely, you want to write some small PL/SQL procedure that accepts parameters from the browser, passes them to the procedures you're really interested in, and then formats the results using the htp output procedures.

steve Received on Tue Oct 08 1996 - 00:00:00 CEST