Re: Max PL/SQL package name size

From: Andrew Protasov <oracle_at_protasov.kiev.ua>
Date: Wed, 2 Dec 98 21:49:55 +0200
Message-ID: <AFZdPPsK42@protasov.kiev.ua>

Hi,

I do not know about 7.3.4. Usually there is no such limit. Each name is limited to 30 characters. Test this by yourself:

SVRMGR> create or replace package p12345678901234567890123456789 as
     2>  function f12345678901234567890123456789 return integer;
     3> end;
     4> /

Statement processed.

SVRMGR> create or replace package body p12345678901234567890123456789 as
     2>  function f12345678901234567890123456789 return integer is
     3>  begin
     4>   return 0;
     5>  end;
     6> end;
     7> /

Statement processed.
SVRMGR> set serveroutput on

Server Output                   ON

SVRMGR> execute dbms_output.put_line(p12345678901234567890123456789.f12345678901234567890123456789); Statement processed.
0

Andrew Protasov

> 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
>
>
>
Received on Wed Dec 02 1998 - 13:49:55 CST