| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| 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?
Your DBA's are definitively wrong. The only limitation I know regarding package/procedure names is 30 characters for *EACH* of them, hence the package_name + function_name can not exceed 60 characters.
Here is an example with length(package_name+proc_name) > 32 characters:
SQL> SET SERVEROUTPUT ON
SQL> CREATE OR REPLACE PACKAGE very_long_package_name AS
2 PROCEDURE very_long_procedure_name;
3 END very_long_package_name;
4 /
Package created.
SQL> CREATE OR REPLACE PACKAGE BODY very_long_package_name AS
2 PROCEDURE very_long_procedure_name IS
3 BEGIN
4 DBMS_OUTPUT.PUT_LINE('long names');
5 END very_long_procedure_name;
6 END very_long_package_name;
7 /
Package body created.
SQL> EXEC very_long_package_name.very_long_procedure_name long names
PL/SQL procedure successfully completed.
>Jim
HTH,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)
 |
 |