Help returning VARCHAR2 from a function

From: Troy Fruetel <Troy.Fruetel_at_connects.com>
Date: Thu, 30 Jul 1998 10:34:03 -0500
Message-ID: <6pq3qu$o96$1@news3.mr.net>

Please respond by e-mail to
Troy.Fruetel_at_connects.com

I've created a function that returns a VARCHAR2, but the function fails if the value to be returned exceeds 200 characters. I want to be able to return VARCHAR2(1000), but that's not allowed. So I created a user-defined subtype of a variable that was VARCHAR2(1000), but that didn't help either. Any ideas?

Neither of the following two methods work:

GetExpression(ExpressionSeqID Number) RETURN VARCHAR2;

temp VARCHAR2(1000);
SUBTYPE ExpressionText IS temp%TYPE;
GetExpression(ExpressionSeqID Number) RETURN ExpressionText;

Thanks
Troy Fruetel
Connect Received on Thu Jul 30 1998 - 10:34:03 CDT