Re: Error with carriage returns embedded in PL/SQL code blocks

From: Lionel Mandrake <nobody_at_nospam.nowhere.nohow>
Date: Tue, 10 Jul 2001 04:50:31 GMT
Message-ID: <rQv27.122118$mG4.60781787@news1.mntp1.il.home.com>

No version numbers... but, you may want to check out bugs 1274195 and 917674 on MetaLink. Different error codes, but exact same description and solution. Fixed in 8.1.7 and included in backports according to MetaLink document (from 27 Dec 2000)...

"Tom Waterhouse" <tomw_at_sabrix.com> wrote in message news:tkkc58q0593v4f_at_corp.supernews.com...
> This appears to be an Oracle specific issue, since it occurs with both the
> Oracle thin JDBC driver and OCI driver. If I attempt to execute a code
> block (declare... begin... end;) and the code has carriage returns ('\r')
> then an error occurs.
>
> declare
> foo number;
> begin
> foo := 5;
> end;
>
> The error is:
>
> java.sql.SQLException: ORA-06550: line 1, column 8:
> PLS-00103: Encountered the symbol "" when expecting one of the following:
>
> begin function package pragma procedure subtype type use
> <an identifier> <a double-quoted delimited-identifier> cursor
> form current
>
>
> If I strip out the carriage returns then the block works just fine.
>
> Know issue?
>
> Tom Waterhouse
> Software Engineer
> Sabrix, Inc.
>
>
Received on Mon Jul 09 2001 - 23:50:31 CDT