Mark,
You could write a plsql by defiining a variable with 32K (like
fetch_log_value varchar2(32760))
You could fetch the long data type column value into fetch_long_value
variable after opening the cursor. After that you can use substr on this
variable.
Baskar
-----Original Message-----
Sent: 04 July 2001 21:56
To: Multiple recipients of list ORACLE-L
HI GURUS,
If I have a table that has a field with long data type and I want to get the
first 250 characters out of it how can I do it. I tried using SUBSTR(long
data type field, 1, 250) but it complained about "ORA-00932: inconsistent
datatypes". I then tried TO_CHAR(SUBSTR(long data type field, 1, 250)) but
still gave me the same result. Tried TO_VARCHAR2 but to no avail.
Thanks,
Mark
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Liggayu
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ramasamy, Baskar
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
