RE: LONG

Nope, you can not use character function like substr,instr with long column.

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Atish Prasad Das
Sent: Thursday, May 11, 2000 3:54 PM
To: Multiple recipients of list ORACLE-L Subject: Re: LONG

Yes, u can use any character function with long in pl/sql....... but in sqlplus this gives datatype mismatch.

• Original Message ----- To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Thursday, May 11, 2000 11:57 AM

Hi guru4s
i want to know if is possible to do a substr or a instr in plsql with a LONG field?
thanks for all,

--
Author: Solis Llera, Eduardo
  INET: esolis_at_mapfre.com

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: ListGuru_at_fatcity.com (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).


--
Author: Atish Prasad Das
  INET: atish.das_at_wipro.com

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: ListGuru_at_fatcity.com (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).