Tickets :: Comment on [#14175] oci8 driver session handler

* Your Email Address
* Spam protection	Enter the letters below: . .. ,.___..__ . \|__\| \./ \| \| \ \| \| \| \| \| \|__/\__\|
Comment	> I think there's a bug passign sql sentence to oci9 driver. > Oracle has a limit of 4000 when writting a blob. It seems to be > needed binding data in Oracle. > > Here is the log: > > Dec 2 17:18:49 DEBUG: HORDE SQL (0,0006s) > SELECT 1 FROM horde_sessionhandler WHERE session_id = > 'e9o7r02bttkvltmr58ord29ap1' [pid 3399 on line 328 of > "/usr/share/pear/Horde/Db/Adapter/Oci8.php"] > Dec 2 17:18:49 DEBUG: HORDE SQL > INSERT INTO horde_sessionhandler (session_id, session_data, > session_lastmodified) VALUES ('e9o7r02bttkvltmr58ord29ap1', > > '5f627c693a313434393037333132393b5f727c693a313434393039343732393b686f7 > ... > > 56e74697479223a22686f726465222c226c6173745f6c6f67696e7461736b73223a226 > > 13a303a7b7d222c22757067726164655f7461736b73223a22613a303a7b7d227d5d7d2 > > 23b733a31333a2273657373696f6e5f746f6b656e223b733a32343a22004679776c474 > d545564386a5348465855466e3162526e7a223b7d', 1449073129) > [pid 3399 on line 313 of "/usr/share/pear/Horde/Db/Adapter/Oci8.php"] > Dec 2 17:18:49 ERR: HORDE SQL QUERY FAILED: ORA-01704: literal de > cadena demasiado largo > INSERT INTO horde_sessionhandler (session_id, session_data, > session_lastmodified) VALUES ('e9o7r02bttkvltmr58ord29ap1', > > '5f627c693a313434393037333132393b5f727c693a313434393039343732393b686f7 > ... > > c79706f736974696f6e223a22626f74746f6d222c2261637469766573796e635f69646 > > 56e74697479223a22686f726465222c226c6173745f6c6f67696e7461736b73223a226 > > 13a303a7b7d222c22757067726164655f7461736b73223a22613a303a7b7d227d5d7d2 > > 23b733a31333a2273657373696f6e5f746f6b656e223b733a32343a22004679776c474 > d545564386a5348465855466e3162526e7a223b7d', 1449073129) > [pid 3399 on line 314 of "/usr/share/pear/Horde/Db/Adapter/Oci8.php"] > Dec 2 17:18:49 DEBUG: HORDE Failed to write session data > (e9o7r02bttkvltmr58ord29ap1) [pid 3399] > > Thank you.
Attachment
Watch this ticket

Saved Queries