Re: functions, pragmas, and a mystery...

From: Peter Laursen <ptl_at_edbgruppen.dk>
Date: 5 Nov 1999 09:59:20 GMT
Message-ID: <01bf277d$811649a0$2c289a0a@apollo>

David Fetter <dfetter_at_shell4.ba.best.com> skrev i artiklen <3822a809$0$210_at_nntp1.ba.best.com>...
>
> What am I missing?
>
> Thanks in advance for any tips, hints, or thoughts on the subject.
>
> Cheers,
> David.
>
> 1 CREATE OR REPLACE PACKAGE analyse_this AS
> 2 FUNCTION foo(table_name_in VARCHAR2)
> 3 RETURN NUMBER;
> 4 PRAGMA RESTRICT_REFERENCES(foo, WNDS);
> 5 END analyse_this;
> 6
> 7 CREATE OR REPLACE PACKAGE BODY analyse_this AS
> 8 FUNCTION foo(table_name_in VARCHAR2)
<snip code>
>
> LINE/COL ERROR
> --------
> -----------------------------------------------------------------
> 7/1 PLS-00103: Encountered the symbol "CREATE"
>

missing a / on line 6?

Peter Received on Fri Nov 05 1999 - 03:59:20 CST