Re: Problem with PL-SQL

From: Morten Steen <no_spam_at_forget.it>
Date: Mon, 7 Jun 1999 11:03:42 +0200
Message-ID: <7jg1ut$b2j$1@news.inet.tele.dk>

Hello there

All you have to do is like this:
CREATE OR REPLACE FUNCTION TEST(VALUE IN NUMBER) RETURN VARCHAR2 IS BEGIN
RETURN('20 CHARACTERS???');
END; This should work RETURN VARCHAR(20) has been replaced with RETURN VARCHAR2

Regards
Morten

Maciej BEDNARSKI skrev i meddelelsen
<928739727.198346_at_casablanca.magic.fr>...
>I would like to know, how can I return a VARCHAR(20) type in PL-SQL
>function. I can't write this
>CREATE OR REPLACE FUNCTION TEST(VALUE IN NUMBER) RETURN VARCHAR(20) IS
>BEGIN
> RETURN('20 CHARACTERS???');
>END;
>
>Must I declare a Subtype or other. Can you send me any samples of code ?
>
>Thanks in advance.
>
>Regard
>
>Maciek
>
>
>
Received on Mon Jun 07 1999 - 04:03:42 CDT