[phplib] 7.2c Problem with oci8 and sessions From: M. Brian Akins (bakins <email protected>)
Date: 07/19/00

The first time a user hits a page they get the following error:

                                                            ORA-00997: illegal use of LONG datatype
                                                        Query :"select count(*) from active_sessions where
val='U29sb19TZXNzaW9uOiR0aGlzLT5pbiA9ICcnOyAkdGhpcy0+cHQgPSBhcnJheSgpOyAkdGhpcy0+cHRbJ2F1dGgnXSA9ICcxJzsgJEdMT0JBTFNbJ2F1dGgnXSA9IG5ldyBTb2xvX0F1dGg7ICRHTE9CQUxTWydhdXRoJ10tPmF1dGggPSBhcnJheSgpOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWyd1aWQnXSA9ICdmb3JtJzsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aFsncGVybSddID0gJyc7ICRHTE9CQUxTWydhdXRoJ10tPmF1dGhbJ2V4cCddID0gJzIxNDc0ODM2NDcnOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWydyZWZyZXNoJ10gPSAnMjE0NzQ4MzY0Nyc7IA=='
                                 and changed='20000719100726' and sid='1b36a7a7f8b1d0a303a6220cef6989c0' and name='Solo_Session'"

When the log in or refresh it's fine.

Thanks.

-- 
M. Brian Akins
Senior Development Engineer

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