php, oracle, OCIExecute()

From: Marcin Wylot <no email>
Date: Fri, 21 Mar 2003 10:41:50 +0100
Message-ID: <gfnl7vsd8bi94oo0ucvqm4a8ct31g26g67_at_4ax.com>

Welcome

I need Yours help about this project:

I have installed on Sun Solaris (2.6) Oracle Database (8.0.5), and apache on the other linux server with PHP and Oracle Client for 9i.

I making a connection to database from Linux to Sun and all is O.K.

For example:

###########################################

<?php
Putenv("ORACLE_HOME=/home/oracle/OraHome1/");
$db="(DESCRIPTION =

     (ADDRESS_LIST =
         (ADDRESS =
           (COMMUNITY = xxx)
           (PROTOCOL = TCP)
           (Host = xxx)
           (Port = xxx)
         )
     )
     (CONNECT_DATA = (SID = TST)
     )

   )";
$conn = OCILogon("user","pass",$db);
$query = "select user_id from fnd_user";
$cursor = OCIParse($conn, $query);
OCIExecute($cursor);
while (OCIFetch($cursor)) {
echo "name: ".OCIResult($cursor,"USER_ID")."<br>"; }
OCILogoff ($conn);
?>

#############################################

When drawn out from bases column is of type int (number) all is ok. Data are presented on page, but when I drawing out of given type Varchar (eg. name) then it doesn't work !

On presented page I see following warnings:

###############################################

Warning: OCIStmtExecute: Error while trying to retrieve text for error ORA-03120 in /var/www/html/oracle/index.php on line 62

Warning: OCIFetch: Error while trying to retrieve text for error ORA-24374 in /var/www/html/oracle/index.php on line 74

###############################################

What is wrong ? bad interpretation data by OCI’s function ?

ENVIRONMENT:

     webserver:
	RedHat Linux 8.0
	Apache 2.0.44 + mod_php 4.3.1
	Oracle Client 9i
     databaseserwer:
          SunOS
          Oracle 8.0.5

Thanks for any help !
Kindly Regards

-- 
Marcin Wylot::m.wylot[at]klub[dot]chip[dot]pl
"Linux is like wigwam - no windows, no gates and apache inside."
"Software is like sex, it's better when it's free."

Received on Fri Mar 21 2003 - 10:41:50 CET