[RESOLVED] Stored Procedure Name Length (A simple question for Oracle users)

Printable View

Sep 19th, 2002, 10:46 PM
abhijit

[RESOLVED] Stored Procedure Name Length (A simple question for Oracle users)

Hi there,
I have a simple and basic question about the Oracle Database.
What is the maximum length that Oracle allows you to maintain for the name of a stored procedure?

If you have people out there who are using TOAD? Does TOAD impose a limit on the length of the name?

Please answer this question.

Thanks & Regards,
Abhijit
Sep 20th, 2002, 07:27 AM
Gaffer

Re: Stored Procedure Name Length (A simple question for Oracle users)

Quote:

Originally posted by abhijit
Hi there,
I have a simple and basic question about the Oracle Database.
What is the maximum length that Oracle allows you to maintain for the name of a stored procedure?

If you have people out there who are using TOAD? Does TOAD impose a limit on the length of the name?

Please answer this question.

Thanks & Regards,
Abhijit

I use TOAD - but I bet the method I use to test how long a procedure name can be is the sam method as you would test it.... i.e. why not try it yourself?

At a rough guess, I'd say 256 would be your maximum - mind you, if I was a programmer abuot to take on a project that has procedures with names > 100 letters, I wouldn't be overly happy....
Oct 28th, 2002, 11:21 PM
abhijit

Gaffer, its actually 30 characters only in Oracle. I wonder where U got that 256 from?

Cheers!
Abhijit
Oct 29th, 2002, 06:21 PM
RSINGH

Quote:

Originally posted by abhijit
Gaffer, its actually 30 characters only in Oracle. I wonder where U got that 256 from?

Cheers!
Abhijit

So why ask?

I have used longer and I was not happy...
Oct 29th, 2002, 10:49 PM
abhijit

I did not know it for a long time till I started reading "Beginning ORacle Programming" From Wrox.

Cheers!
Abhijit
Oct 30th, 2002, 08:47 AM
Gaffer

Quote:

Originally posted by abhijit
Gaffer, its actually 30 characters only in Oracle. I wonder where U got that 256 from?

Cheers!
Abhijit

err, I said "at a rough guess" it's 256 (a pretty common number used in programming)
Mar 12th, 2012, 09:57 AM
foluis

Re: Stored Procedure Name Length (A simple question for Oracle users)

Is there a way to in increase stored procedure length names?
Mar 16th, 2012, 12:40 PM
abhijit

Re: Stored Procedure Name Length (A simple question for Oracle users)

Quote:

Originally Posted by foluis

Is there a way to in increase stored procedure length names?

No. There is no way. This limit is imposed by the database. You cannot increase the stored procedure length.

SIDENOTE:
Wow, how did you get this thread resurrected?