Re: Problem with PL-SQL
Date: Mon, 7 Jun 1999 11:03:42 +0200
Message-ID: <7jg1ut$b2j$1_at_news.inet.tele.dk>
[Quoted] 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
[Quoted] 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 - 11:03:42 CEST