RE: [phplib] ORA-00997: illegal use of LONG datatype From: Rogers, Paul (Paul.Rogers <email protected>)
Date: 04/19/01

Hi Mark

I had this problem, and after some investigation found the following

ORA-00997: illegal use of LONG datatype
Cause: A value of datatype LONG was used in a function or in a DISTINCT,
WHERE, CONNECT BY, GROUP BY, or ORDER BY clause. A LONG value can only be
used in a SELECT clause.

at

http://technet.oracle.com/doc/server.804/a58312/toc.htm

It appears the long datatype can only be used in very simple select
statements, hence the error message when the count (*) function is used.

I got round this by changing the val column in active_sessions to the
varchar2(2000) type. 2000 is the largest size available for varchar.

This doesn't appear to have broken anything (yet) :o), but I'd be interested
if any one else had any comments regarding possible problems, performance
issues etc.

All the best

Paul

-----Original Message-----
From: Faine, Mark [mailto:Mark.Faine <email protected>]
Sent: 18 April 2001 20:42
To: 'phplib <email protected>'
Subject: [phplib] ORA-00997: illegal use of LONG datatype

I get this error on the first page (login page) of my application:

Warning: OCIStmtExecute: ORA-00997: illegal use of LONG datatype in
db_oci8.inc on line 69

ORA-00997: illegal use of LONG datatype
Query :"select count(*) from active_sessions where
val='UmVwb3NpdG9yeV9TZXNzaW9uOiR0aGlzLT5pbiA9ICcnOyAkdGhpcy0+cHQgPSBhcnJheSg
pOyAkdGhpcy0+cHRbJ2F1dGgnXSA9ICcxJzsgJEdMT0JBTFNbJ2F1dGgnXSA9IG5ldyBSZXBvc2l
0b3J5X0F1dGg7ICRHTE9CQUxTWydhdXRoJ10tPmF1dGggPSBhcnJheSgpOyAkR0xPQkFMU1snYXV
0aCddLT5hdXRoWyd1aWQnXSA9ICdmb3JtJzsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aFsncGVybSd
dID0gJyc7ICRHTE9CQUxTWydhdXRoJ10tPmF1dGhbJ2V4cCddID0gJzIxNDc0ODM2NDcnOyAkR0x
PQkFMU1snYXV0aCddLT5hdXRoWydyZWZyZXNoJ10gPSAnMjE0NzQ4MzY0Nyc7IA==' and
changed='20010418144104' and sid='47513b97d83dd4c5d89f22115fe467b8' and
name='Repository_Session'"
_____________________________________
Thanks

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

*****************************************************************************
This email and any attachments transmitted with it are confidential
and intended solely for the use of the individual or entity to whom
they are addressed. If you have received this email in error please
notify the sender and do not store, copy or disclose the content
to any other person.

It is the responsibility of the recipient to ensure that opening this
message and/or any of its attachments will not adversely affect
its systems. No responsibility is accepted by the Company.
*****************************************************************************

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