Hi all,
I'm using a PL-SQL extension for Apache (mod_pl sql)
This extension allows to generate HTML from Oracle Stored Procedures.

The core section of the configuration is this:

<Location /plsql>
SetHandler pls_handler
Order deny,allow
Allow from all
AllowOverride None

PlsqlDatabaseUsername         scott
PlsqlDatabasePassword         tiger
PlsqlDatabaseConnectString    ORACLE_HP
PlsqlAuthenticationMode       Basic
</Location>

Here all requests that begin with /plsql are elaborated with
mod_pl_sql.

for example:
http://localhost/plsql/MyProcedure

calls MyProcedure and prints html code in it.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - -
What I need now is to proxy every request to plsql with another call
like this:

http://localhost/plsql/init?userName=user

Because I need to carry the session information between calls.

In other words I need to say to Apache that when anything like

http://localhost/plsql

is issued, this should be issued before:

http://localhost/plsql/init?userName=user.

I hope it's possible to do it somehow...........
Thanks a lot
Laura

[ Post a follow-up to this message ]

On 20 Giu, 16:49, Laura <f.marchi...@pride.it> wrote:
> Hi all,
> I'm using a PL-SQL extension for Apache (mod_pl sql)
> This extension allows to generate HTML from Oracle Stored Procedures.
>
> The core section of the configuration is this:
>
> <Location /plsql>
>   SetHandler pls_handler
>   Order deny,allow
>   Allow from all
>   AllowOverride None
>
>   PlsqlDatabaseUsername         scott
>   PlsqlDatabasePassword         tiger
>   PlsqlDatabaseConnectString    ORACLE_HP
>   PlsqlAuthenticationMode       Basic
> </Location>
>
> Here all requests that begin with /plsql are elaborated with
> mod_pl_sql.
>
> for example:http://localhost/plsql/MyProcedure
>
> calls MyProcedure and prints html code in it.
> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
> - - - - - - - - -
> What I need now is to proxy every request to plsql with another call
> like this:
>
> http://localhost/plsql/init?userName=user
>
> Because I need to carry the session information between calls.
>
> In other words I need to say to Apache that when anything like
>
> http://localhost/plsql
>
> is issued, this should be issued before:
>
> http://localhost/plsql/init?userName=user.
>
> I hope it's possible to do it somehow...........
> Thanks a lot
> Laura

Sigh.....no way ?
Is there a chance with mod_rewrite ?
What I exactly need is to "filter" a request with another
request........

For example in Java it's possible to filter a Servlet request with a
Servlet filter. Unfortunately I cannot use the same pattern here
because the Java Web Server kicks in only for .jsp pages and not for
html pages. (Apache is in front of Tomcat web server)

So I need to find a similar solution with Apache.......
please help!

[ Post a follow-up to this message ]