Re: stored function problem

From: River <wychan_at_vol.net>
Date: Tue, 04 May 1999 07:30:44 +0800
Message-ID: <372E31A4.E893C156_at_vol.net>


But, stored function don't allow the return type is varchar2 and don't allow of specifying the length.

I am discussing the stored function at database side, not in Form.

Thanks for any advice,
River

JR wrote:

> You are mixing types.
> content is varchar2, so your function should return varchar2:
> create or replace get_content ( sys_code in char ) return varchar2
>
> This should work fine.
> JR
>
> River <wychan_at_vol.net> wrote in message news:372D99EF.A25311D2_at_vol.net...
> > Question about a very simple stored function:
Received on Tue May 04 1999 - 01:30:44 CEST

Original text of this message