Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Max PL/SQL package name size
On 2 Dec 1998 15:55:56 GMT, "Jim" <lermontovb_at_hotmail.com> wrote:
>We recently upgraded to Oracle Server 7.3.4 (from 7.3.3). Our DBAs (I'm a
>developer) claim there is a maximum <package name> + <function name> size
>limit of 32 characters.
>Does anyone know if this is true or if they just got the wrong end of the
>stick?
>Jim
There is a limit of 30 characters for an object name. So the maximum package_name + function_name is 60.
eg.
Connected to:
Oracle7 Server Release 7.3.4.0.1 - Production
With the distributed, replication, parallel query and Spatial Data
options
PL/SQL Release 2.3.4.0.0 - Production
SQL> create or replace
2 package A12345678901234567890123456789 as
3 procedure p12345678901234567890123456789;
4 end;
5 /
Package created.
SQL> create or replace
2 package body A12345678901234567890123456789 as
3 procedure p12345678901234567890123456789 is
4 begin
5 dbms_output.put_line( 'Hello' );
6 end;
7 end;
8 /
Package body created.
SQL> exec
A12345678901234567890123456789.p12345678901234567890123456789
Hello
PL/SQL procedure successfully completed.
SQL> Add one more character to the name and ...
SQL> create or replace procedure p123456789012345678901234567890 as
2 begin
3 null;
4 end;
5 /
create or replace procedure p123456789012345678901234567890 as
*
ERROR at line 1:
ORA-00972: identifier is too long
hope this helps
chris.
--
Chirstopher Beck
Oracle Corporation
clbeck_at_us.oracle.com
Reston, VA.