[phplib] Showoff.php Oracle Cursor and Parse errors?? From: j.t.montgomery (j.t.montgomery <email protected>)
Date: 04/02/01

I'm getting to persistant errors in the PHPLib showoff.php
I have upgraded the pages to the sessions4.inc and dependent files, but
problem was there prior to the upgrade. Can someone suggest what causes
these 2 errors, please
:
The two errors occur on showoff.php
=========================================
Table class test
Database error:
ora_parse() failed:
SELECT
T.table_name,T.column_name,T.data_type,T.data_length,T.data_precision,T.data
_scale,T.nullable,T.char_col_decl_length,I.index_name FROM ALL_TAB_COLUMNS
T,ALL_IND_COLUMNS I WHERE T.column_name=I.column_name (+) AND
T.table_name=I.table_name (+) AND T.table_name=UPPER('active_sessions')
ORDER BY T.column_id
Snap & paste this to sqlplus!
Oracle Error: 904 (ORA-00904: invalid column name -- while processing OCI
function OPARSE)

Warning: No tuples available on this cursor in db_oracle.inc on line 153

==========================================after active_sessions data table
:-

Warning: 4 is not a valid Oracle-Cursor resource in db_oracle.inc on line
153

Warning: 4 is not a valid Oracle-Connection/Cursor resource in db_oracle.inc
on line 160

Warning: 4 is not a valid Oracle-Connection/Cursor resource in db_oracle.inc
on line 167

Warning: 4 is not a valid Oracle-Cursor resource in db_oracle.inc on line
153

Warning: 4 is not a valid Oracle-Connection/Cursor resource in db_oracle.inc
on line 160

Warning: 4 is not a valid Oracle-Connection/Cursor resource in db_oracle.inc
on line 167
 End of your active_sessions data
===========================================

My System parameters :
  There are two systems involved - an NT which hosts the PHPLib application,
    and a Sun System which hosts Oracle database.
    - phplib_7_2 is on both with seaaion4 file set prepending.
    - php is version 4.0.4pl1
    - Oracle is a legacy Oracle7 Server Release 7.3.3.0.0 - Production
carrying
        auth_user,Active_sessions, etc.
    - Apache is Apache/1.3.14

Thanks for any help.
:-)
John

---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>