Re: PL/SQL FUNCTION can't compile!

On Wed, 11 Oct 2000 09:40:23 +0800, jos <NOSPAMjosmoi_at_post.com> wrote:

>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
Create or Replace FUNCTION dd(mid in out VARCHAR)

    RETURN NUMBER
 IS
>Begin
> return 0;
>End;
 End dd;
>
>Begin
> DBMS_OUTPUT.PUT_LINE(dd('A'));
>End;
>/
 show errors dd;
OR
 show errors function dd;
depending on version
and read the error messages
>----------------------------
>
>Can someone pls tell me what is wrong with this program? It doesn't
>look wrong to me!
>
>Thank you
>

Thanks. Take care, Brian Inglis Calgary, Alberta, Canada

-- 
Brian_Inglis_at_CSi.com 	(Brian dot Inglis at SystematicSw dot ab dot ca)
				use address above to reply