Problem with PL-SQL
From: Maciej BEDNARSKI <mb_at_infotrans.fr>
Date: Mon, 7 Jun 1999 09:22:20 +0200
Message-ID: <928739727.198346_at_casablanca.magic.fr>
[Quoted] [Quoted] 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; [Quoted] Must I declare a Subtype or other. Can you send me any samples of code ?
Date: Mon, 7 Jun 1999 09:22:20 +0200
Message-ID: <928739727.198346_at_casablanca.magic.fr>
[Quoted] [Quoted] 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; [Quoted] Must I declare a Subtype or other. Can you send me any samples of code ?
[Quoted] Thanks in advance.
Regard
Maciek Received on Mon Jun 07 1999 - 09:22:20 CEST