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
kalkumar
Messages: 8
Registered: July 2007
Junior Member
Hi,
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: 64152
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

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


Current Time: Sun Dec 11 00:31:01 CST 2016

Total time taken to generate the page: 0.07251 seconds