Home » SQL & PL/SQL » SQL & PL/SQL » Stored procedure name length in Oracle
Stored procedure name length in Oracle [message #251199] Thu, 12 July 2007 12:22 Go to next message
Messages: 8
Registered: July 2007
Junior Member
can any one provide me link or specify what is the limitation for the stored procedures names/function names in Oracle 10G. And variable name lenth limitations.

Thanks in advance.
Re: Stored procedure name length in Oracle [message #251203 is a reply to message #251199] Thu, 12 July 2007 12:38 Go to previous message
Michel Cadot
Messages: 65088
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
30 characters as (almost) all identifiers.

SQL Reference
Chapter 2 Basic Elements of Oracle SQL
Section Schema Object Names and Qualifiers

Previous Topic: sql vs pl/sql
Next Topic: Dynamic Search Queries
Goto Forum:

Current Time: Wed Jul 26 06:00:17 CDT 2017

Total time taken to generate the page: 0.11195 seconds