Re: [phplib] Showoff.php Oracle Cursor and Parse errors?? From: Jesse Swensen (swensenj <email protected>)
Date: 04/02/01

I have not seen this error specifically, but two thoughts come to mind.

First, it may be you do not have privileges to the two tables (views)
ALL_TAB_COLUMNS T or ALL_IND_COLUMNS I. You may have to grant those
privileges.

Second, as the error messages indicates, there may be a problem with the
Table class test script and it is trying to access a column that does not
exist. May be a typo... 

-- 
Jesse Swensen
swensenj <email protected>

> From: "j.t.montgomery" <j.t.montgomery <email protected>>
> Organization: Northern College of Education
> Reply-To: "j.t.montgomery" <j.t.montgomery <email protected>>
> Date: Mon, 2 Apr 2001 13:14:12 +0100
> To: <phplib <email protected>>
> Subject: [phplib] Showoff.php Oracle Cursor and Parse errors??
> 
> 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>
> 
> 

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