Re: Problem with PL-SQL

Exactly as you wrote it, except leave out the (20) in your declaration and return varchar2.
The function wants to know what to return, it doesn't care about the length

CREATE OR REPLACE FUNCTION TEST(VALUE IN NUMBER) RETURN VARCHAR2 IS BEGIN
  RETURN('20 CHARACTERS???');
END; Mark

Maciej BEDNARSKI wrote in message <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 - 10:15:25 CEST