Re: URGENT !! SQL*PLUS Error !!

Re: URGENT !! SQL*PLUS Error !!

[ Follow Ups ] [ Post Followup ] [ Message Board ]

Posted by 'John' on September 04, 2001 at 16:53:22 EST:

In Reply to: URGENT !! SQL*PLUS Error !! posted by 'DdOracle' on August 28, 2001 at 17:18:15 EST:

: Hi,
: I get the following error when I execute this SELECT statement:

: SELECT COLNAME FROM TBLNAME;

: ERROR: SQL*Plus internal error state 2132, context 0:0:0
: Unsafe to proceed.

: The COLNAME is of datatype CLOB.
: How can I fix this??

: Quick help is highly appreciated.

: Thanx,
: DdOracle

You can't use a select statement to read a CLOB or any other binary column. Depending on your development environment there is probably another way of reading the data. You can also change the datatype to VARCHAR2(4000) if you can live with the limitation of 4000 characters per field in non-unicode format. 2000 unicode.

Follow Ups:

Post a Followup

Name:
E-Mail:
Subject:
Message: : : Hi, : : I get the following error when I execute this SELECT statement: : : SELECT COLNAME FROM TBLNAME; : : ERROR: SQL*Plus internal error state 2132, context 0:0:0 : : Unsafe to proceed. : : The COLNAME is of datatype CLOB. : : How can I fix this?? : : Quick help is highly appreciated. : : Thanx, : : DdOracle : You can't use a select statement to read a CLOB or any other binary column. Depending on your development environment there is probably another way of reading the data. You can also change the datatype to VARCHAR2(4000) if you can live with the limitation of 4000 characters per field in non-unicode format. 2000 unicode.