Greetings,
I built php 4.2.1 and am having database access troubles. The problem
shows up with either the php module for apache/stronghold or the
command line/standalone version of php, so I've been using the stand alone
version.
I believe that my syntax and test program is correct, because a slightly
different sql statement works while others fail.
Here is the version information:
php: 4.2.1
gcc -v
Reading specs from
/opt/tools/gcc-2.95.1/lib/gcc-lib/sparc-sun-solaris2.7/2.95.1/specs
gcc version 2.95.1 19990816 (release)
Oracle 7.0.15 statically linked in
Below is my test program. The output is within the test program itself.
Thanks in advance for any help.
Chip
<?php
Putenv("ORACLE_HOME=/opt/tools/oracle/home/oracle/product/7.0.15");
$connection = Ora_Logon ("batch","gpz058");
if ($connection == false){
echo Ora_ErrorCode($connection).":1 ".Ora_Error($connection)."<BR>\n";
exit;
}
$cursor = Ora_Open ($connection);
if ($cursor == false){
echo Ora_ErrorCode($connection).":2 ".Ora_Error($connection)."<BR>\n";
exit;
}
/* WORKS and gives
$query = "SELECT * FROM ALL_TABLES";
Numcols: 20
Column: Type: Size: Result:
--------------------------------------------
0 VARCHAR2 30 SYS
1 VARCHAR2 30 CDEF$
2 VARCHAR2 30 SYSTEM
3 VARCHAR2 30 C_COBJ#
4 NUMBER 22 0
*/
/* HOSED and gives
$query = 'SELECT TABLE_NAME, OWNER FROM ALL_TABLES';
PHP Warning: Ora_GetColumn found invalid type (0) in
/export/home/sun/chip/build/php-4.2.1/index4.php on line 75
/export/home/sun/chip/build/php-4.2.1/index4.php(75) : Warning - Ora_GetColumn
found invalid type (0)
Numcols: 2
Column: Type: Size: Result:
--------------------------------------------
0 VARCHAR2 30
1 UNKNOWN(0) 0
2
3
4
*/
$query = 'SELECT TABLE_NAME, OWNER FROM ALL_TABLES'; /* HOSED */
$result = Ora_Parse ($cursor, $query);
$result = Ora_Exec ($cursor);
if ($result == false){
echo Ora_ErrorCode($cursor).":4 ".Ora_Error($cursor)."<BR>\n";
exit;
}
$numcols = ora_numcols ($cursor);
echo "Numcols: $numcols\n";
echo "Column: Type: Size: Result:\n";
echo "--------------------------------------------\n";
/* Just look at 5 for debugging purposes.
*/
if ($numcols > 5)
{
$cols_to_print = 5;
}
else
{
$cols_to_print = $numcols;
}
for ($i = 0; $i < $cols_to_print; $i++)
{
$t = ora_columntype ($cursor, $i);
$s = ora_columnsize ($cursor, $i);
$result = ora_getcolumn ($cursor, $i);
echo "$i $t $s $result\n";
}
Ora_Close ($cursor);
Ora_Logoff ($connection);
?>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
