Re: Dreaded PLS-123 Error

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Thu, 9 Nov 2006 23:03:14 +0200
Message-ID: <6e49b6d00611091303m7509058btf1c072e194773013@mail.gmail.com>

2006/11/9, Ethan Post <post.ethan_at_gmail.com>:
> I am getting PLS-123 trying to compile a large audit type trigger on a table
> with about 300 columns.

<snipped>

Can't you just call some packaged procedure and put the logic there? Packages have much greater limit for their sizes check metalink note 62603.1 'PLS-123 Program too Large' - Size Limitations on PLSQL Packages

Gints Plivna
http://www.gplivna.eu

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Nov 09 2006 - 15:03:14 CST