Current Position:Home > Oracle 10g HTTP Server + PHP

Oracle 10g HTTP Server + PHP

Update:12-10Source: network consolidation
Advertisement
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.

The Best Answer

Advertisement
Your existing PHP already extracts as binary - that's what is causing
a problem.
The two functions I mentioned convert to ASCII using their respective
encodings. What format you want depends on what you want to do with
the string.
Here is some code that may be helpful.
<?php
// Fetch a RAW and convert to a hexidecimal representation similar to
// fetching it as a SQLT_STR
$c = oci_connect("hr", "hr", "XE");
// Create test table
$s = oci_parse($c, "create table rtable(rcol raw(2000))");
oci_execute($s);
// Load first 2000 bytes of the test.gif image into the RAW
$img = file_get_contents( dirname(__FILE__)."/test.gif");
$img = substr($img, 0, 2000);
$s = oci_parse ($c, "insert into rtable (rcol) values (:bv)");
oci_bind_by_name($s, ":bv", $img, -1, SQLT_BIN);
oci_execute($s);
// Query the RAW and convert to one form of ASCII representation
$stid = oci_parse($c, 'select rcol from rtable');
oci_execute($stid);
print '<table border="1">';
while ($row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS)) {
  echo "<tr><td>";
  echo bin2hex($row['RCOL']);
  echo "</td></tr>\n";
echo '</table>';
// Clean up
$stmt = oci_parse($c, "drop table rtable");
oci_execute($stmt);
?>-- cj
  • Deployment of class file in oracle 10g Application Server Update:10-11

    Hi, I have a class file import java.io.*; import javax.servlet.*; import javax.servlet.http.*; public class HelloWorld extends HttpServlet { public void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException { res

  • Urgent: problem running reports in Oracle 10g application server Update:10-11

    Hi all, our problem is that we deployed a jsp report as Ear file in Oracle 10g application server in infrastructure node.deployment says successfull.when we try to run that report it says 401 unauthorised.while sending request we are passing the data

  • How to set the debug port for Eclipse for OracleAS 10g Enterprise Server Update:10-11

    Hi All, I want to debug a java class, which is exposed as webservice. what are the settings I need to do in OracleAS 10g Enterprise Server to debug a java class using a eclipse. Thanks in advance, Vidyasagar.Hi, have you double checked that your oc4j

  • Win32 Oracle 10g Database Server Installation problems Update:10-11

    Hello, I have recently installed the Oracle 10g Database Server for Win32. The installation seemed to be successful. I used the Enterprise option and all the suggested defaults. Ihave the following services installed and started after the installatio

  • Installation of Oracle 10g Application Server in custom port or 1522 Update:10-11

    I want to install Oracle 10g Application Server in Port 1522 or some other port as in port 1521 Oracle 10g database server is already installed. But every time I try to install Oracle 10g Application Server it give the warning about 1521 port and the

  • Deploying Oracle Retail Applications in Oracle 10g Application Server Update:11-30

    Hi All.. Can anyone help me to know: How to Deploy Oracle Retail Applications(like RMS,ReIM,RIB) in Oracle 10g Application Server. Regards.Hi Ahmed, It sounds you have not yet had the chance to lay eyes on the installation guides - they are not perfe

  • Auditing in oracle 10g database and oracle 10g application server Update:11-30

    Dear friends, We have oracle 10g application server and oracle 10g database server in place.My criteria is to audit users connected using oracle application user credentials to the database. Can you please tell me how can i do it. Thanks & regards,It

  • Oracle Applicatiton Server on Oracle 10g DB server Update:11-30

    Hope you are able to help me out, I have got the Oracle 10g DB server and Oracle Application Server on the same Red Hat Enterprise 4.4 server. When I try to start the Application server it gives me the error: [ons-listener] Bind failed to 127.0.0.1 t

  • Setting of ICONS in Oracle 10G Application Server Update:11-30

    Hi... I'm facing a problem of Icons which are not displayed at run time. I'm using Oracle 10G Application Server. plz tell what setting should i do. its urgent. Thanks & Regards Sanjeev Kumar1 did u put the icon file in the forms folder in IAS? 2 Are