Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Problem with PL-SQL
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
![]() |
![]() |