Re: strange behaviour of sp

In article <00ec19b3.03278abd_at_usw-ex0104-026.remarq.com>,   luio <lctNOlcSPAM_at_hotmail.com.invalid> wrote:
> after I created a sp.
>
> no matter what I put after my
> is,
> like no matter if change line after that.
>
> it will always report, that
> encounter "" whenexpecting the beginning of declare.
> I can solve it by delete one white space or put one white space
> before my declare, the stp will become valid.
> it will keep valid after I put that space back or delete it to
> make the sp exactly same as the original invalid sp.
>
> -----------------------------------------------------------
>
> Got questions? Get answers over the phone at Keen.com.
> Up to 100 minutes free!
> http://www.keen.com
>
>

The keyword declare is not used in stored procedures, functions and packages. The keyword declare is used in anonymous blocks and triggers. So remove the declare and it will work.

Hth,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com http://www.deja.com/
Before you buy.