[PHP] PHP3 and Oracle 8.1.6

[Bob Kakalec]

I am trying to install and configure PHP3 with Oracle 8.1.6 and am
receiving the following error when I run $ make

In file included from functions/php3_oci8.h:53,
 from internal_functions.c:53:
/stuff/oracle/product/8.1.6/rdbms/demo/oci.h:1659: ociextp.h: No such
file or directory
make: *** [internal_functions.o] Error 1
[bob@rojo /php-3.0.16]#

I verified that the file is not there.

Here is how I configured php3:
./configure --with-apxs=/usr/local/apache/bin/apxs
--with-config-file-path=/etc/httpd
--with-oracle=/stuff/oracle/product/8.1.6

Any suggestions or ideas as to what might be wrong?

Is it possible to run 8.1.6 with PHP3?  or do I need PHP4?

I am using RedHat 6.0

Thanks,

Bob K


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP] Oracle CLOB and PHP

[Bob Kakalec]

Hello,

I am trying to execute a simple SELECT from Oracle 8.1.6 in a
php4.0.3pl1  page.

 $sql_get_info="SELECT ID, Title, CLOB FROM Employee WHERE ID=37";

  if ($cursor = ora_do($connection, $sql_get_info)) {
$valid_opp_title = ora_getcolumn($cursor, 0);//id
$valid_opp_text = ora_getcolumn($cursor, 1);//title
$valid_opp_sort_flag = ora_getcolumn($cursor, 2);//CLOB
  }

and I get the following error:

Warning: Ora_Do failed (ORA-00932: inconsistent datatypes -- while
processing OCI function OEXFET) in /direcotry/file.php

If I take out the reference to the clob field, my page works fine.  Once
I add it, it blows-up.

Here is how I configured Apache 1.3.12
 './configure' '--with-apxs=/staples/apache/bin/apxs'
'--with-config-file-path=/shoes/httpd'
 '--with-oracle=/bob/bobagain/bobapp/oracle/product/8.1.6'

Any idea what I am doing wrong?  I am using the clob field because I
need to store text documents that may be longer than 4000 characters.

Thanks,

Bob K



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP] PHP and Oracle Zombie processes

[Bob Kakalec]

When I execute an sql statement against my Oracle database from PHP, I
create an  oracle  process.  This eventually hits a "number of
zombie process" limit and prevents my page from executing.

The queries work properly (except for the zombie problem).

Here is a sample that creates the zombie process:

putenv("ORACLE_HOME=/h/app/oracle/product/8.1.6");
putenv("ORACLE_SID=dbase_name");
putenv("TNS_ADMIN=/h/app/oracle/product/8.1.6/network/admin");//
thought this might help the zombie problem

$conn=OCILogon("get_rid_of" , "zombie");

$sql_get_info="SELECT OppID, OppTitle  FROM TEST WHERE OppID=4";
$stmt = OCIParse($conn,$sql_get_info);

OCIExecute($stmt);

OCIFetch($stmt));

$valid_opp_id = OCIResult($stmt, "OPPID");
$valid_opp_title = OCIResult($stmt, "OPPTITLE");

OCIFreeStatement($stmt);

/ using  a separate query to get the clob..
$clob_field="OPPTEXT"; // this field in UPPPER CASE
$sql="SELECT $clob_field from TEST WHERE OppID=$oid";

$stmt = OCIParse($conn, $sql);
$clob_text = OCINewDescriptor($conn,OCI_D_LOB);
OCIDefineByName($stmt, $clob_field, &$clob_text);
OCIExecute($stmt);
OCIFetch($stmt);
$valid_text=$clob_text->load();

$clob_text->free();
OCIFreeStatement($stmt);



Here is how I configured PHP 4.0.3pl1 (this is from phpinfo();) :

./configure --with-apxs=/usr/local/apache/bin/apxs
--with-config-file-path=/etc/httpd
--with-oracle=/ora8/m01/app/oracle/product/8.1.6

I also added OCI8 support via..
--with-oci8=/ora8/m01/app/oracle/product/8.1.6  ... phpinfo(); states
oci8 support is "enabled".

I did --enable-sigchild  but I don't see it showing in the phpinfo();
???

I am using: Oracle 8.1.6,   Apache 1.3.12 , RedHat 6.0  - all on one
server.

Any ideas on what I might be doing wrong?  Am I missing something?   Any
help would be greatly appreciated.

Thanks,

Bob






-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]