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 -> Problem with PL-SQL

Problem with PL-SQL

From: Maciej BEDNARSKI <mb_at_infotrans.fr>
Date: Mon, 7 Jun 1999 09:22:20 +0200
Message-ID: <928739727.198346@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 - 02:22:20 CDT

Original text of this message

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