Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Problem with PL-SQL

Re: Problem with PL-SQL

From: Mark Gumbs <mgumbs_at_nospam.hotmail.com>
Date: Mon, 7 Jun 1999 09:15:25 +0100
Message-ID: <375b7d50.0@145.227.194.253>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US