Re: PL/SQL compatibility in Oracle 9.2.0.2

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Sun, 24 Aug 2003 12:21:37 +0200
Message-ID: <384hkvsg9vtvsh2vsv796if00nhoufcft2@4ax.com>

On Sun, 24 Aug 2003 09:40:50 GMT, "Claus Østby Nielsen" <cni_at_privat.dk> wrote:

>I can easily understand the ora-06511 failure as the developer has used goto
>to exit the loop which has been a no-no for the last 20 years.

Not to speak of the rest of the crap you posted. Limiting a select based on rownum, with hardcoded constants everywhere.... Somehow most programmers never got out of the hacking phase of their existence

>
>I can't understand why the development environment allow the statement to
>execute.
>

Nor can I understand why Oracle would have allowed to execute this code at all. But did you check the compatibility init.ora parameter?
>We have recently patched the OS at the production server (Solaris 32-bit)
>and relinked the Oracle binaries, but I can't see why this should have any
>such impact.

Not sure why you are still running 32-bit. All recent Solaris servers have 64 bit capability and Oracle is moving away from 32 bit.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sun Aug 24 2003 - 05:21:37 CDT