Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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 - 03:15:25 CDT