RE: function return string

From: Shaw, Glen <Glen.Shaw_at_BellSouth.com>
Date: Fri, 13 Oct 2000 11:10:16 -0400
Message-Id: <10648.119192@fatcity.com>

Depends on what version of the database you are running. 7.3.4: VarChar2 goes to 2,000 characters. Above that you will have to use a long. (Major pain)
8.x.x: VarChar2 goes to 4,000 characters. Above that you should use a CLOB. -----Original Message-----
From: sigit [mailto:irianto_at_postmaster.co.uk] Sent: Friday, October 13, 2000 11:26 AM
To: Multiple recipients of list ORACLE-L Subject: function return string

Dear all,

I have to create stored function
that return string (very long ones , >10000 char) as its return value. Im not sure about what data type that meets my needs.
I've used LONG,CLOB,VARCHAR2 but that didn't help.

Any ideas?

Thanx,
Harry
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: sigit
  INET: irianto_at_postmaster.co.uk

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). Received on Fri Oct 13 2000 - 10:10:16 CDT