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
