Re: PL/SQL FUNCTION can't compile!

Thanks for helping! I removed the scale but it is still giving me warnings!

Valgaeren Dirk wrote:

> 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 - 12:31:55 CEST