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."

-- 
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."

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to