Re: PL/SQL FUNCTION can't compile!
From: Valgaeren Dirk <DValgaeren_at_Cereus.BE>
Date: Wed, 11 Oct 2000 10:38:57 +0200
Message-ID: <8s18t0$7l6$1_at_naxos.belnet.be>
Date: Wed, 11 Oct 2000 10:38:57 +0200
Message-ID: <8s18t0$7l6$1_at_naxos.belnet.be>
Replace dd(mid in out varchar2(5)) by dd(mid in out varchar2)
you can't specify a scale in the parameters
jos <NOSPAMjosmoi_at_post.com> schreef in berichtnieuws
39E3C506.77A05DBC_at_post.com...
> Hi all,
>
> I tried to compile a simple piece of code but I keep getting "Warning:
> Function created with compilation errors."
>
> This is my program:
> ---------------------------
> Create or Replace FUNCTION dd(mid in out VARCHAR2(5)) RETURN NUMBER IS
> Begin
> return 0;
> End;
>
> Begin
> DBMS_OUTPUT.PUT_LINE(dd('A'));
> End;
> /
> ----------------------------
>
> Can someone pls tell me what is wrong with this program? It doesn't
> look wrong to me!
>
> Thank you
>
>
Received on Wed Oct 11 2000 - 10:38:57 CEST