Skip to Main Content

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.

can't compile PHP5.2 with Oracle ORA support, please help!

558892Jan 29 2007 — edited Jan 31 2007
Hi peoples,

first post on here - hope someone can assist.

I am compiling PHP 5.2 on RedHat Enterprise 4 AS intel 64bit with oracle ORA and LDAP support compiled in. I am using Apache 2.0.52-28 installed from RedHat RPMs.

I am using the following configure line:

./configure with-apxs2=/usr/sbin/apxs with-config-file-path=/etc/httpd/conf with-oracle=/export/oracle/pegasus/product/9.2.0 with-ldap=/usr enable-sigchild enable-libgcc

The only oracle related messages I have found during the configuration are:

checking for Oracle (OCI8) support... no
checking Oracle OCI support for PDO... no

However I am told these are newer methods of Oracle communication protocols and not related to what I am trying to achieve.

After building and installing PHP 5.2, reconfiguring apache httpd.conf and restarting httpd I find that the output of phpinfo.php shows no mention of oracle whatsoever apart from the Configure Command section at the beginning confirming that yes, --with-oracle= was specified.

I have tried setting ORACLE_HOME=/export/oracle/pegasus/product/9.2.0 environment variable before running ./configure but to no avail.

I have also tried adding various Oracle environment variables to my startup scripts for Apache, also to no avail.

Any ideas? I am really under the pump to get this sorted as it is for a new production server here and I am limited timewise to get it up and running.

Cheers

Andy

Comments

fac586

APEX$ROW_STATUS is only relevant to rows in interactive grids and (historically) tabular forms. It is not supported on DML Form regions and so is returning null on the form page.
The form page process would need to use PK and/or :request values to determine which DML operation is to be performed.

Ceci Loveland

Thanks!
I changed my PK to be the app_id. For now, just to test, I removed all conditions and made it simply an update. I even tried setting the page number of the values, but the code basically never touches the table (with or without the page number). There's no error, nothing is updated though.
update PLP_PLUSLOANPROC_X
set PLP_USER_ID = :P3_PLP_USER_ID,
PLP_COMMENTS = :P3_PLP_COMMENTS,
PLP_COMPLETED_STATUS = :P3_PLP_COMPLETED_STATUS
where PLP_APP_ID = :P3_PLP_APP_ID;

I'm obviously misunderstanding something.

fac586

What is logged when the page is submitted in debug mode?

Ceci Loveland

I figured it out. It was a dumb mistake. I hadn't set the execution options to be "once per page visit" instead of per session.
Thank you!

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 28 2007
Added on Jan 29 2007
4 comments
1,725 views