Bug #17539
closedOCI_INVALID_HANDLE
0%
Description
When I watch some pages in the frontend I get this error:
Warning: OCI-Lob::save() [function.OCI-Lob-save]: OCI_INVALID_HANDLE in D:\IIS\EMS\typo3\sysext\adodb\adodb\drivers\adodb-oci8.inc.php on line 696
My database is oracle 10g.
I think, it's something like bug nr. 0005535 (it's closed, so I opened a new issue-report.).
(issue imported from #M6164)
Updated by Karsten Dambekalns about 17 years ago
So, did you use the latest SVN version?
Updated by Moreno Feltscher about 17 years ago
Where can I get the SVN version?
I think, the error occurs, if I visit a page the first time. So can it be because of the cache-functionality?
Updated by Moreno Feltscher about 17 years ago
Now I also get this error when I insert a new content element:
Warning: ociexecute() [function.ociexecute]: ORA-01704: string literal too long in ...\typo3\sysext\adodb\adodb\drivers\adodb-oci8.inc.php on line 1017
Updated by Moreno Feltscher about 17 years ago
Another error now when I try to index external documents like PDF:
Warning: ociexecute() [function.ociexecute]: ORA-00001: unique constraint (INTRANET.SYS_C0090792) violated in ...\typo3\sysext\adodb\adodb\drivers\adodb-oci8.inc.php on line 1017
In the dbal-Log I see this (example):
sqlError ORA-00001: unique constraint (INTRANET.SYS_C0090792) violated
INSERT INTO "index_words" ( "wid", "baseword", "metaphone" ) VALUES ( '88728859', 'schalter', '212743736' )
Updated by Moreno Feltscher almost 17 years ago
I tried the SVN-version. I also dropped tt_content and recreated it with the install-tool. Now all VARCHAR2 columns became CLOB, nice done. But if I try to add new content I get this error:
Versuch einen Datensatz auf Seite 'ORA-00932: inconsistent datatypes: expected CLOB got CHAR' (tt_content:NEW475e89a46f341) ohne die nötigen Berechtigungen einzufügen. (Oder die Seite existiert nicht!) (msg#1.1.12)
Updated by Michiel Roos over 15 years ago
I have seen this when using the 'Western European' Oracle Express 10g on a UTF-8 dataset.
Patrick Broens tipped me that character set conversions may be in the way here.
After re-installing the whole system using a 'Universal' Oracle Express 10g database with the same dataset, my problems went away.
Maybe send a reminder to Moreno. If he can still reproduce and gives some 'steps to reproduce', I will help to debug. Otherwise, close the bug.
Updated by Moreno Feltscher over 15 years ago
This bug can be closed. At the end (and with some debugging work) all worked fine.
Thank you for your support!