Re: PL/SQL FUNCTION can't compile!

Thank you for all the help here! Actually removing the scales in the parameters work! The bug came from other places in the original program as well.

Jos wrote:

> 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 - 16:51:56 CEST