Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle HTTP Server + PHP

413546May 23 2005 — edited Jun 15 2005
Does anyone know how to enable PHP support on Oracle HTTP Server (from Oracle DB Companion CD)? I tried to compile PHP on it, bet I get the following error:

Configuring SAPI modules
checking for AOLserver support... no
checking for Apache 1.x module support via DSO through APXS...

Sorry, I was not able to successfully run APXS. Possible reasons:

1. Perl is not installed;
2. Apache was not compiled with DSO support (--enable-module=so);
3. 'apxs' is not in your path. Try to use --with-apxs=/path/to/apxs
The output of /u01/app/oracle/product/10.1.0/cp_1/Apache/Apache/bin/apxs follows
ld.so.1: /u01/app/oracle/product/10.1.0/cp_1/Apache/Apache/bin/httpd: fatal: libdms2.so: open failed: No such file
or directory
apxs:Error: Sorry, no DSO support for Apache available
apxs:Error: under your platform. Make sure the Apache
apxs:Error: module mod_so is compiled into your server
apxs:Error: binary `/u01/app/oracle/product/10.1.0/cp_1/Apache/Apache/bin/httpd'.
configure: error: Aborting

Oracle HTTP server does not have DSO support, is there some possibility to enable it? Or there exists another way to enable PHP support on Oracle HTTP server.

Comments

M. Kelnhofer-Oracle
Hi,

this is an important question.
In fact the online help is right: Before its execution the query is parsed and data fetching is strarted.
Thus any plsql operation that may influence the query and the data accessed is too late in the BEFOREREPORT trigger.

THe issue is that there is no error message or warning. THe problem scenario bandwidth is wide: From "no problem at all" to constant or intermittent error scenarios or worst case unrecognized problems like missing records or any strange behavior in the layout.

So very carefull while using BEFOREREPORT trigger

Ciao
Markus
1 person found this helpful
user12024310
thanks for the reply,

In that case, in what scenario we would need a before report trigger. Isn't it almost the same as After report trigger ?

Regards,
Suresh
InoL
Well, that is confusing. In the help (of 6i) about Report trigger order of execution it says:

(...)
5 Queries are parsed.
6 Before Report trigger is fired.
7 SET TRANSACTION READONLY is executed (if specified via the READONLY argument or setting).
8 The report is executed and the Between Pages trigger fires for each page except the last one.
(...)
In steps *7 through 9, avoid DML* statements that would modify the contents of the tables on which the report is based.
(...)

That would indicate that DML is possible in step 6!
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 13 2005
Added on May 23 2005
#php
2 comments
1,220 views