| End of File on Communication Channel [message #55162] |
Wed, 08 January 2003 06:34  |
SSV
Messages: 11
Registered: October 2002
|
Junior Member |
|
|
Hello all ,
My server is windows NT
Database version : 8.1.7
Front end: ASP
I have below Query as a part of "ASP application "
select * from sampletab
where dbms_lob.instr(clobcol,'hello')>0;
when i am calling the page, It waits and gives me an error " End of File on Communication Channel. "
why is that so ?
Is it because of the CLOB Column in the backend table. ?
Please correct me..
I am badly in need of solution...
Help will be Appreciated..
Thanks and Regards
Vj
|
|
|
|
| Re: End of File on Communication Channel [message #55194 is a reply to message #55162] |
Thu, 09 January 2003 16:57  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
It should work just fine. I tested it:
"Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
JServer Release 8.1.7.4.0 - Production
select * from demo
where dbms_lob.instr(testcol,'hello')>0;
SQL> create table demo (
2 testcol clob);
Table created.
SQL> insert into demo values ('hello world');
1 row created.
SQL> insert into demo values ('bye world');
1 row created.
SQL> commit;
Commit complete.
SQL> select * from demo
2 where dbms_lob.instr(testcol,'hello')>0;
TESTCOL
-------------------------------------------------
hello world
"
Do you have any entries in the alert log? Any trace files??
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
