Is a length of 10000 even valid for a VARCHAR2? Rich Rich Jesse System/Database Administrator rich.jesse@xxxxxxxxxxxxxxxxx QuadTech, Sussex, WI USA > -----Original Message----- > From: Igor Neyman [mailto:ineyman@xxxxxxxxxxxxxx] > Sent: Thursday, February 26, 2004 11:39 AM > To: oracle-l@xxxxxxxxxxxxx > Subject: RE: URGENT - HELP ORA-06502: > > > What error says, is that l_str variable in FUNCTION Fmemo_text is too > small to hold the result of concatenation. > > Igor Neyman, OCP DBA > ineyman@xxxxxxxxxxxxxx > > > > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Oracle > Sent: Thursday, February 26, 2004 12:13 PM > To: oracle-l@xxxxxxxxxxxxx > Subject: URGENT - HELP ORA-06502: > > Hi, > > I have the following 2 Tables: > > CONCAT_MEMO_TEXT - > MTSN NUMBER(10) > MEMO_TEXT VARCHAR2(4000) > > NC_MEMO_TEXT - > MTSN NUMBER(10) > TEXT_ORDER NUMBER(10) > MEMO_TEXT VARCHAR2(255) > R_STATUS VARCHAR2(1) > > This function: > > CREATE OR REPLACE FUNCTION Fmemo_text (p_mtsn IN NUMBER) > return VARCHAR2 is > l_str VARCHAR2(10000); [snip] ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------