[Phplib-trackers] [ phplib-Bugs-511639 ] ORA-00997 (phplib 7.4 pr1)

[<no...@so...>]

Bugs item #511639, was opened at 2002-02-01 04:56
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=403611&aid=511639&group_id=31885

Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Rune Kallhovd (choozo)
Assigned to: Nobody/Anonymous (nobody)
Summary: ORA-00997 (phplib 7.4 pr1)

Initial Comment:
PHP 4.0.4.pl1, Oracle 8.1.7

When setting up the basics and accessing the
../pages/index.php3 file, I get the following error:

"Warning: OCIStmtExecute: ORA-00997: illegal use of
LONG datatype in /usr/local/apache/php/db_oci8.inc on
line 69"

"ORA-00997: illegal use of LONG datatype 
Query :"select count(*) from active_sessions where
val='RXhhbXBsZV9TZXNzaW9uOiR0aGlzLT5pbiA9ICcwJzsgJHRoaXMtPnB0ID0gYXJyYXkoKTsgJHRoaXMtPnB0WydzJ10gPSAnMSc7ICRHTE9CQUxTWydzJ10gPSAnMSc7IA=='
and changed='20020201104234' and
sid='e4b3d2080c584cb390de104b299ff54a' and
name='Example_Session'"

 -----------------------------------------

Editing the function 'ac_store()' ($squery) in
ct_sql.inc as follows 'fixes' this, but this is
probably not what one want to do?:

(removed "val='%s'" from the 'sprintf()', and commented
'$str'.)

$squery = sprintf("select count(*) from %s where
changed='%s' and sid='%s' and name='%s'",
      $this->database_table,
      # $str,
      $now,
      $id,
      $name); 

 ------------------------------------------

Cheers :-)

----------------------------------------------------------------------

>Comment By: Jesse Swensen (swensenj)
Date: 2002-07-03 17:18

Message:
Logged In: YES 
user_id=168883

You can not use a LONG data type in the where clause.  The fix 
presented would fix the problem, but we should make sure the fix works 
across the other databases.

----------------------------------------------------------------------

Comment By: Chris Johnson (chaska)
Date: 2002-07-03 16:47

Message:
Logged In: YES 
user_id=279065

Could it be that the active sessions table is not defined 
correctly?  That column should be "text" or the Oracle 
equivalent (sorry I don't remember -- haven't done Oracle 
in 3 years).

..chris

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=403611&aid=511639&group_id=31885