Home » SQL & PL/SQL » SQL & PL/SQL » A query with LOB's requires OCI8 mode, but OCI7 mode is used.
A query with LOB's requires OCI8 mode, but OCI7 mode is used. [message #162012] Wed, 08 March 2006 03:47 Go to next message
rvnair123
Messages: 26
Registered: January 2006
Junior Member
Hello,
I have a table with comments column as VARCHAR2(4000).
I updated column with charaters length nearly 4000.
when i select the value back i concatenate it like
'User'||author||'wrote' ||on||comments.
Now it gives me error ORA-01489: result OF string concatenation IS too LONG
I tried to convert whole string with TO_CLOB function,then when i select record I get error
"A query with LOB's requires OCI8 mode, but OCI7 mode is used."
How can i get around without doing alter table modify column???

Thanks,
Rekha
Re: A query with LOB's requires OCI8 mode, but OCI7 mode is used. [message #215703 is a reply to message #162012] Tue, 23 January 2007 10:18 Go to previous messageGo to next message
asafm
Messages: 2
Registered: January 2007
Location: Israel
Junior Member
rvnair123 wrote on Wed, 08 March 2006 11:47
Hello,
I have a table with comments column as VARCHAR2(4000).
I updated column with charaters length nearly 4000.
when i select the value back i concatenate it like
'User'||author||'wrote' ||on||comments.
Now it gives me error ORA-01489: result OF string concatenation IS too LONG
I tried to convert whole string with TO_CLOB function,then when i select record I get error
"A query with LOB's requires OCI8 mode, but OCI7 mode is used."
How can i get around without doing alter table modify column???

Thanks,
Rekha



I get the same error, when I do the following:
select DBMS_METADATA.Get_DDL('TABLE', 'SCOTT')
from dual
Re: A query with LOB's requires OCI8 mode, but OCI7 mode is used. [message #215825 is a reply to message #215703] Wed, 24 January 2007 00:49 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
which tool do you use? Which version?
Re: A query with LOB's requires OCI8 mode, but OCI7 mode is used. [message #216011 is a reply to message #215825] Wed, 24 January 2007 11:24 Go to previous messageGo to next message
asafm
Messages: 2
Registered: January 2007
Location: Israel
Junior Member
I found out my error.
I was using PLSQL Developer, and querying DBMS_METADATA_Get_DDL(...)

I forogt to wrap it with DBMS_LOB.substr(), to get a VARCHAR2 out of it, since PLSQL Developer can't handle LOB's in my version.
Re: A query with LOB's requires OCI8 mode, but OCI7 mode is used. [message #483735 is a reply to message #162012] Wed, 24 November 2010 05:51 Go to previous messageGo to next message
nitinkumarbe
Messages: 8
Registered: June 2009
Junior Member

Hi
You can use dbms_lob.substr() function to overcome the error message. Please visit http://www.protalk.in/oracle/a-query-with-lobs-requires-oci8-mode-but-oci7-mode-is-used-solution-for-plsql-developer-5-1-3/

I got the issue solved and i can able to query CLOB values in PL/SQL Developer 5.1

Thanks
Nitin
Re: A query with LOB's requires OCI8 mode, but OCI7 mode is used. [message #483756 is a reply to message #483735] Wed, 24 November 2010 07:24 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
You can use dbms_lob.substr() function to overcome the error message

Is this not what the previous user have said almost 4 years ago?

Regards
Michel
Previous Topic: Ora-22289 ,ora-22288 using demo mail (merged)
Next Topic: Days wise separation
Goto Forum:
  


Current Time: Tue Dec 06 00:04:44 CST 2016

Total time taken to generate the page: 0.08133 seconds