Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Max length of stored procedure name

363 views
Skip to first unread message

S Fundarek

unread,
Apr 2, 1997, 3:00:00 AM4/2/97
to

Can anyone tell me what the maximum length is for the *name* of a stored
procedure, function or package in Oracle 7.x?

I can't seem to find this in my manuals.

Thanks

Steven Fundarek
sfw...@idirect.com

QuadTwin

unread,
Apr 6, 1997, 4:00:00 AM4/6/97
to

Steven Fundarek sfw...@idirect.com wrote:

> Can anyone tell me what the maximum length is for the *name* of a
> stored procedure, function or package in Oracle 7.x?
>
> I can't seem to find this in my manuals.
>
> Thanks
>

30 characters.


Al Lawson
Interactive Group, Inc.
www.interactive-group.com
law...@interactive-group.com


Thomas kyte

unread,
Apr 6, 1997, 4:00:00 AM4/6/97
to

Identifiers are limited to 30 characters (table names, column names,
procedures, variables, etc)...


On Wed, 02 Apr 1997 09:13:59 -0500, S Fundarek <sfw...@idirect.co_>
wrote:

>Can anyone tell me what the maximum length is for the *name* of a stored
>procedure, function or package in Oracle 7.x?
>
>I can't seem to find this in my manuals.
>
>Thanks
>

>Steven Fundarek
>sfw...@idirect.com


Thomas Kyte
tk...@us.oracle.com
Oracle Government
Bethesda MD

http://govt.us.oracle.com/ -- downloadable utilities

----------------------------------------------------------------------------
Opinions are mine and do not necessarily reflect those of Oracle Corporation

L120bj

unread,
Apr 7, 1997, 3:00:00 AM4/7/97
to

Subject: Max length of stored procedure name
From: S Fundarek <sfw...@idirect.co_>
Date: Wed, 02 Apr 1997 09:13:59 -0500
As with all objects, the maximum length for the name is 30 chars.

Rob
--------------------------------------------------------------------------
--------------------------------------------
Message-ID: <334269...@idirect.co_>

0 new messages